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.

Yes to do this type of automation, you can use the addin

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

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!!


"alex" wrote in message
oups.com...
Thanks for the response. Could you be a bit more specific. I'm an
Outlook beginner.

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!!


"alex" wrote in message
oups.com...
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?

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 wrote:

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.

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