Mail Merge from excel

Hi Experts,

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.

please help!

peggiegreg
LVL 2
peggiegregAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Norm DickinsonGuruCommented:
The mail merge would be done traditionally in a word processing or graphic design program, not from within Excel - although that could be done. Here is what I do.

Go to MS Word, (I am using 2010 edition, yours may be different) and click on the "mailings" tab, then "start mail merge" button. Then click "select recipients" (the next button over) and choose "use existing list" - and then find your Excel file in the dialog box. Excel is just used for the list, not the entire mail merge.

The steps are described further in this article: https://support.office.com/en-ca/article/Use-mail-merge-to-create-and-print-letters-and-other-documents-f488ed5b-b849-4c11-9cff-932c49474705

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.