MailMerge Date with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Wadsworth - 07 Jul 2004 15:56 GMT

When merging a date from an Excel spreadsheet with a Word
document, which ever way I enter or format the date entry
in Excel it turns it into an American date style in the
Word document. I want UK style ie dd/mm/yyyy. There are
answers here for a similar problem for Word/Access merges.
Can someone please help for a Word/Excel merge?

Regards

Reply to this Message

Doug Robbins - 08 Jul 2004 01:12 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> When merging a date from an Excel spreadsheet with a Word
> document, which ever way I enter or format the date entry
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message

Graham Mayor - 08 Jul 2004 04:52 GMT

The issues relating to Word and Excel are the same - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When merging a date from an Excel spreadsheet with a Word
> document, which ever way I enter or format the date entry
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message