Mailmerge in Word, date format in merged doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brownsox - 13 Jan 2005 15:11 GMT

I have been using mailmerge with an Excel data source for 3 years. I created
a new worksheet for 2005 and something has gone wrong.
First, opening the Word doc no longer automatically opens the Excel file.
In fact unless I open the Excel file before the Word file, it says the Excel
file is locked for editing - although it's not apparently open at all. The
other way round , it's ok.
Secondly, there are 2 date fields in the data source, with custom format. I
enter eg 1/9 (UK order) and the worksheet correctly shows September 1. The
mailmerge letter/email also used to show September 1. But now it shows 9/1
(US order). I cannot imagine how this has happened or work out how to fix
it. HELP!

Reply to this Message

Doug Robbins - 14 Jan 2005 00:58 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

>I have been using mailmerge with an Excel data source for 3 years. I
>created
[quoted text clipped - 12 lines]
> (US order). I cannot imagine how this has happened or work out how to fix
> it. HELP!

Reply to this Message

brownsox - 14 Jan 2005 12:29 GMT

Thank you - that has sorted the date problem (found Mailmerge helper and
reset to use DDE). Opening the mailmerge doc now also opens the Excel file,
as before. Great.
BUT it is reading data from the wrong worksheet - I have tried entering the
correct sheet name (2005) in the helper dialogue but it doesn't work. Any
help gratefully received. I suppose I could delete the old sheets but don't
really want to - and it should surely not be necessary?
Thanks.

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 17 lines]
> > (US order). I cannot imagine how this has happened or work out how to fix
> > it. HELP!

Reply to this Message