Using Outlook to create/read mailing lists

  • Thread starter Thread starter alex
  • Start date Start date
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.
 
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!!
 
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?
 
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!!
 
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.
 
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.
 
Back
Top