Outlook 2007 Mail Merge multiple emails

D

Dr. Hackenbush

Hello would like some advice/help please

I am using Outlook 2007 , Excel 2007, Word 2007.

I have a spreadsheet that i use to keep around 300 records on a clubs
membership. I would like to send them their renewal/update letters via
Email.
Before I was aware that Outlook had a Mail Merge facility I had already
prepared the letters using Word 2007 and Mail Merge.

Can this be done in Outlook, ie; send out 300 individual Emails with each
members own details merged from Excel on the Email, but with me only
actually producing one master template with multiple fields linked to a data
source(Excel), like i have done in Word ?

So far, I have imported all the Email addresses from each members record in
Excel, into Outlooks Contacts and made a distribution list

Now, using that Distribution list how do I produce an individual Email to
each of the addresses on that list with merged data.

I have looked for some tutorials on Google but not seen anything that seems
to do what i want. Maybe i have missed something obvious here or maybe it
cant be done, either way i have reached a mental impasse !

Hope this all makes sense if not i can provide more info

I am open to all offers of advice,suggestions, workarounds etc !

I'm off to work now so wont be able to check back here until tonite, but
thanks for your time in advance

Cheers'n'Beers
 
R

Russ Valentine [MVP-Outlook]

You can use either Outlook Contacts or your Excel spreadsheet as the
datasource for a mail merge. You cannot use a DL. Help files will answer all
your questions.
 
D

Dr. Hackenbush

Ok , got there in the end. I actually found the help slightlyconfusing in
this instance.

It was actually easier than i thought, it was staring me in the face D'oh. I
spent more time thinking about what to do instead of actually going ahead
and doing it, live and learn !

Thanks for replying


Russ Valentine said:
You can use either Outlook Contacts or your Excel spreadsheet as the
datasource for a mail merge. You cannot use a DL. Help files will answer
all your questions.
--
Russ Valentine
[MVP-Outlook]
Dr. Hackenbush said:
Hello would like some advice/help please

I am using Outlook 2007 , Excel 2007, Word 2007.

I have a spreadsheet that i use to keep around 300 records on a clubs
membership. I would like to send them their renewal/update letters via
Email.
Before I was aware that Outlook had a Mail Merge facility I had already
prepared the letters using Word 2007 and Mail Merge.

Can this be done in Outlook, ie; send out 300 individual Emails with each
members own details merged from Excel on the Email, but with me only
actually producing one master template with multiple fields linked to a
data source(Excel), like i have done in Word ?

So far, I have imported all the Email addresses from each members record
in Excel, into Outlooks Contacts and made a distribution list

Now, using that Distribution list how do I produce an individual Email
to each of the addresses on that list with merged data.

I have looked for some tutorials on Google but not seen anything that
seems to do what i want. Maybe i have missed something obvious here or
maybe it cant be done, either way i have reached a mental impasse !

Hope this all makes sense if not i can provide more info

I am open to all offers of advice,suggestions, workarounds etc !

I'm off to work now so wont be able to check back here until tonite, but
thanks for your time in advance

Cheers'n'Beers
 

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

Top