Trouble with <blank> dates in merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Kelly - 11 Feb 2004 14:16 GMT

I am creating a simple directory, merging data from Excel 2002 to Word
2002. Each instance of a <blank> Date field in the Excel file causes
Today's Date to show up in the merged doc.

Any thoughts?

Thanks,
Paul

Reply to this Message

Graham Mayor - 11 Feb 2004 15:08 GMT

You can either use a conditional field to detect a blank field and insert
something appropriate or revert to the old method of connection to the
data - see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am creating a simple directory, merging data from Excel 2002 to Word
> 2002. Each instance of a <blank> Date field in the Excel file causes
[quoted text clipped - 4 lines]
> Thanks,
> Paul

Reply to this Message