Software

How do I use mail merge in Word 2007?

Choose database and table

If you provided valid connection information then you should now see the databases listed in the drop down list. Select the appropriate database and then the tables available should be provided in the list below.

Select the table that contains your recipient data and click Next.

You should now be presented with a screen similar to the columns screen when we imported via the csv file.

11 comments
saruti
saruti

Good article but it would be really useful to know how to add an attachment to an email that is going to multiple people. As an example I want to send a cover letter and a copy of my resume to 10 different recruiters from my contact list. Thanks sam

cfraioli
cfraioli

I would love to have this info available as a pdf file also!

saruti
saruti

Great article what it is missing is how to add an attachment to the mailing.

fshamk
fshamk

Wish it was in pdf or printable format.anyways thanks

bobwright
bobwright

How about a printer friendly version of the article?

simran
simran

Very Nice !! Wish you'll could have posted the same as a PDF Download. The PDF format enables us to easily save it for future reference. Great Work though !! Rgds, Prakash.

DonG43
DonG43

Seems MS has forgotten their own Office database, Access. They have not had a good mail merge with Access data since Office 2000. Can't select a query, the selection options are poor. This means you have to go through the entire selection and sort issues with every mail merge.

Larry3500
Larry3500

OK, I now have a custom set of letters to a group of Outlook Contacts. Why would I want to print and snail-mail them? I want to Send them, emailing each to the specified Contact.

parier
parier

I always add a new column, call it "Sorted" and set the sort in that field. If I need a specific filter sort, I will add a new column called "FILTER" field and set it that way. This allows my to better separate and sort my date when merging. I can include or exclude parts as well as sort them. I can even have multiple sort types by including my FILTER fields. ...or... Filter and sort manually, then save separate XLS files for each sort. Then when merging you don't have to verify the data as anything there is only for that particular sort.

parier
parier

You can use mail-merge for email distribution, the same way you would do for printing, but instead choose To Email (not Send To from File Menu), HOWEVER...you need to check what your outbound limit is from your ISP....attachments for bulk distribution is frowned upon and can lead to service termination. Its best if you will be proving an attachment to reference a URL in your doc to a web location. 1000ish emails x small attachment = LARGE MAIL QUEUE and server strain. I use a PHP app for distributions, fully supports HTML, love it. One issue I had with Office (e)mail-merge was all emails would queue, sit in the outbox (Bold, meaning unread) and never send. I would have to open, then close each of the emails...then it would send - I wouldn't even have to make a change. I uninstalled and reinstalled twice - really annoying.