I have a list of email address's in excel and I want to be able to send a generic email to all contacts.
I am assuming this is done using Mail Merge unless you can think of a better way of doing it.
I cant seem to understand how mail merge works.
so just to clarify this is what I am trying to achieve, the bit in bold is the part I don't know how to do in the process:
- receive email lead from 3rdparty with info on
- extract emails - using a macro in outlook which dumps them all into an excel spread sheet 2003
- take email list from excel spread sheet and sends a generic email to recipients.