Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stlof - 28 Sep 2006 15:37 GMT
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.
Signature

haf

Peter Jamieson - 28 Sep 2006 18:08 GMT
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

>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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.