Mail Merge (2003)

Topic

New Reply

I’ve been trying to create a mail merge from an Excel data source which includes a Calculated field using the a combination of if and isblank functions. It displays correctly in the spreadsheet, but when merged displays as zeros instead of blank. I can’ t find guidance on formatting the word mergefields to eliminate the problem, am I missing something?

Thanks

Reply | Quote

Replies

In Word, select Tools | Options…
Activate the General tab.
Tick the check box “Confirm conversion at Open”.
Click OK.

Now go back to step 3 of the mail merge wizard (task pane).
Click “Select a different list” and navigate to your Excel workbook.
You’ll be prompted to select a method to connect to the workbook.
Instead of the default OLE DB, choose either “Microsoft Excel Worksheet via Converter” or “MS Excel Worksheets via DDE” and click OK.
Proceed as usual.
Blanks should now remain blanks in the merged document, instead of becoming zeros.

Reply | Quote

Many thanks

Reply | Quote

Thanks for this, Hans,
I’ve just had a cognate problem and your fix worked (so far….)

Reply | Quote