asked on

Mail Merge Works in Office 2003, Fails in Office 2007

I've got a user on Vista running Office 2007. She has a document to email out to about 900 individuals, and has set-up a mail merge using Word 2007 and Outlook 2007. She gets through all the steps with no problems, however, it stops sending after about 6 emails. We can take the same mail merge to another Vista machine running Office 2003 and it runs and delivers the mail successfully.

Has anyone else run into this problem or know how to fix it?

Karen Falandays

Hi anordquist, is ther any error message? It just stops? What happens if user merges to a document instead of printer?
kfalandays

anordquist

ASKER

There's no error message. The progress wheel in Word continues to spin. The user's Sent Mail folder shows a few of the messages having gone out.

I'll ask the user to try merging to a document and let you know what happened.

Karen Falandays

Two other things to try..1. Have user remove and re-add the data source to the mail merge document to re-establish the link and 2. Make sure you lave SP1 update for Office 2007
kfalandays

anordquist

ASKER

I had the user run the merge using the entire contents of the spreadsheet, about 900 email recipients, and printed the output to the Microsoft Image file. It seemed to be ok, but I don't know of a way to count pages inside of the picture editor, so had the user run the merge again with just 5 recipients and printed the result to a laser printer. All 5 copies came out.

Karen Falandays

The merge options give a choice to merge to Word file...will that help? Each page will print on one Word page...

anordquist

ASKER

No, that really doesn't help. We do want these to get emailed out.

Karen Falandays

OK, then def try to re-attach the data source
kfalandays

anordquist

ASKER

We've tried reattaching the data source, but don't get any further. I don't know what would cause the link between Word and Excel to fail after half-a-dozen emails went out (Vista, Office 2007) when doing the same things on (Vista, Office 2003) works fine.

ASKER CERTIFIED SOLUTION

anordquist

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Modwild

I was going through this problem with the exact same scenario except I was using all 2007 Office products. I was so frustrated, and it brought me here. I tried one last time to successfully merge the rest of my data, and it worked.

It only worked AFTER I HAD CLOSED OUTLOOK! I didn't even realize it was closed, as I had opened and closed Outlook and Word so many times from crashes after sending the 7 or so emails and quitting. This last time I forgot to open Outlook and merged from within Word...the remaining hundreds of emails went without a hitch. I might suggest that anyone who runs into this problem with Word 2007 email merge closes Outlook for results!