How do I use an Excel data source to send broadcast mails?

L

Lexy

Hi,

I need to send a Newsletter out via email and have the list of recipients in
an excel file. I'm fairly new to Office 2007 and having thought it would be
simple to find the info (i.e. merging the email addresses into Outlook), am
actually stuck.

Has anyone done this and could you offer me some guidance please?

Thank you
 
R

Roady [MVP]

You'll need to start your Mail Merge from Word and set the Excel sheet as
the source.
 
B

Brian Tillman

Roady said:
You'll need to start your Mail Merge from Word and set the Excel
sheet as the source.
Click to expand...

Will Word 2007 use an Excel 2007 spreadsheet as a source, or does it need to
be an Excel 2003 or earlier sheet?
 
R

Roady [MVP]

Yes, that is supported. It's just Outlook's Import/Export Wizard that is
still not updated to support the new file formats and Access 2007 databases.
Luckily Access 2007 does a much better job supporting Outlook then the other
way around.
 

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

Similar Threads

how do I send emails to the same contact at multiple email addres 1
How do I send an email to many people (as "undisclosed recipients" 7
Outlook template with multiple drafts of content prior to sending 1
How do I send an email with read-only content (i.e. newsletter) UR 5
How do I send a mass e-mail using an Excel database? 6
how do I draft an email for someone else to send out? 3
How do I send an email newsletter to every address in my Contacts. 2
How do I send a newsletter in Outlook? 5

Top