I have a question regarding mail merge. I enter information into a fairly large excel workbook and print invoices in word using mergefields from the workbook. Once the invoices have been printed, I save the workbook under another name as I need to keep the original version. This worked fine until I had to re-load Office 2010 onto my PC. Now, the invoices will not pick up the data unless I first save the excel spreadsheet. Once my invoices have printed, I now have to go back into the spreadsheet and change all the data back to how it was before I saved it. Does anyone have any idea why this change should have come about and how I can rectify it? Thank you.

Hi Joanne,

You might get better results by saving the Excel workbook with the new name before merging, then changing the mailmerge main document to point to the new file.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]