Outlook 2007 Mail Merge multiple emails

  • Thread starter Thread starter Dr. Hackenbush
  • Start date Start date
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
 
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.
 
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
Click to expand...
Click to expand...
 
Back
Top