merging blank cells from excel to word i want them to stay blank n

S

stlof

I am creating a membership roster which denotes education attainment by
abbreviations. Where the course has not been taken, I want to show a blank.
When I mail merge from Excel XP to Word XP, some blank fields remain blank,
some come over as 0.
 
P

Peter Jamieson

The simplest short term fix for this is usually to change the way Word
connects to Excel - check Word Tools|Options|General|"Confirm conversions at
open", reconnect to the data source, and select the DDE option when it is
offered.

Peter Jamieson
 

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

Merging from an Excel file with graphics 1
Conditional Mail Merge won't suppress blank lines 2
Blank Date Field in Merge 3
Blank Fields in Word 2007 Merge 1
Word Mail Merge From Excel Data 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Delete Blank Lines with Word 2007 Mail Merge 5
Mail Merge - displaying a conditional number of decimals 5

Top