Mail Merge

[denice]

Office 2K on a PC- Mail Merge from excel to word. When information is blank in excel it merges as a zero on word document. Checked to ensure that fields are formatted in excel as "text".
Im stuck
your help is greatly appreciated

~D

Denice
Mac OSX, Running Classic for Quark 4.1. System G4.

 

[TropicalFred]

Not sure that formatting will help you here. An empty cell is an empty cell regardless of format. You may need to actually have something in the cell, a single quotation mark or a space for example, to prevent it from coming across as a zero. Hope this helps.

TropicalFred

 

[BlueHorizon]

Hi denice,
Try this in Excel - Tools|Options|View tab. Remove the checkmark from zero values. This might help prevent your problem.
HTH,


Best,
Blue Horizon

http://www.bluehorizontraining.com