Using Outlook to create/read mailing lists

A

alex

I recently installed Outlook in my office and would like it to do some
automated tasks. Specifically, automated email to my employees based
on a spreadsheet or database. If I have an individuals name on a
spreadsheet, is it possible to link Outlook to that spreadsheet
(let's say in Excel) and create a mailing list? I'm using Outlook
'03 and my employees are already on a list in Outlook.

Any help would be appreciated.
 
A

alex

Thanks for the response. Could you be a bit more specific. I'm an
Outlook beginner.
 
J

Judy Gleeson

what do you mean by "based on a spreadsheet"

If the people you wish to merge to are in Contacts, then select them, Tools
| Mailmerge | merge to email | write the subject and OK. Word starts up.
Use Insert Merge field and then merge to email.


Judy Gleeson
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!
 
A

alex

By spreadsheet, I mean an Excel or Access doc. Say for example that I
have 500 employees and as a result of a database sweep I identify 50
that I want to email. How do I enable Outlook to talk to Excel or
Access and relate what's in the spreadsheet to what's in an Outlook
address list?
 
J

Judy Gleeson

Why don't you just do an email merge from the selected records from Access
or Excel? No need to relate to Contacts at all.

Or alternatively, hold all of the data in Contacts and select the people
there and email merge to them?

Judy Gleeson
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!
 
A

alex

I tried to merge the records. Keep in mind that I don't have their
email addresses in Excel. I have only have their names. I need
Outlook to recognize the name and then associate an email address.
 
B

Brian Tillman

alex said:
I tried to merge the records. Keep in mind that I don't have their
email addresses in Excel. I have only have their names. I need
Outlook to recognize the name and then associate an email address.
Click to expand...

That won't happen, as far as I can tell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Problems created by Recent updates to Outlook 365 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Mail Merge query 1
Unable to decode certain emails in my web mail since setting up outlook 2007 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Create Hyperlink in Task Window Body, to Search for Emails FromSpecific Address 0
Start a mail merge upon opening the document 1

Top