Date mail merge field shows as serial

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hiking - 28 Feb 2005 14:00 GMT

Hello all,

I have a Word document with a mail merge field which picks up a date
from an Excel document, so whatever date is in the Excel document is
merged into the Word document.

This used to work fine before we upgraded from MS Office 2000 to MS
Office XP. Now the imported/merged date shows as a serial number. I've
looked in the menus and also right-clicked on the field in question in
my Word document to try to edit the field's properties, but find no
where to change the way the date will display.

Any suggestion appreciated. Thanks.

Reply to this Message

Graham Mayor - 28 Feb 2005 15:32 GMT

See http://www.gmayor.com/formatting_word_fields.htm and/or the Excel data
section of 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hello all,
>
[quoted text clipped - 9 lines]
>
> Any suggestion appreciated. Thanks.

Reply to this Message

Hiking - 28 Feb 2005 22:02 GMT

> See http://www.gmayor.com/formatting_word_fields.htm and/or the Excel data
> section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

One of those links suggested that the solution was to revert to DDE
connection to Excel, though the instructions were not complete, I did
figure out a way to get it done.

Thank you very much, I never would have suspected that MS would have
completely changed the way Word connects to Excel... what a bunch!

Reply to this Message

Graham Mayor - 01 Mar 2005 07:48 GMT

In what way was my web site instruction incomplete? It even includes
illustrations!

Signature

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

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

>> See http://www.gmayor.com/formatting_word_fields.htm and/or the
>> Excel data section of
[quoted text clipped - 6 lines]
> Thank you very much, I never would have suspected that MS would have
> completely changed the way Word connects to Excel... what a bunch!

Reply to this Message

Hiking - 17 Mar 2005 21:03 GMT

> In what way was my web site instruction incomplete? It even includes
> illustrations!

Sorry Graham, been non-stop busy with big project here at work. I had
been using Office 2000 here all along, and a co-worker has Office XP, so
I decided to install and try, then had productivity slow-downs as a
result of variations in the packages (little behavioral changes and
such), so just uninstalled Office XP and re-installed Office 2000 in
order to get back to work.

When we're done with this project and the workload lightens, I'll try
the XP version again and give you more details on whatever it was that I
was prompted, or selection that I wasn't certain of between the
screenshots you have on your site. Possibly there is nothing missing,
possibly I'd missed a detail in the instruction you have on the site.
I'll let you know.

Reply to this Message

Graham Mayor - 18 Mar 2005 11:25 GMT

Please do that. If the web page isn't clear, I would like to make it so.
However over the next few months I am in the throes of relocating to another
country so my access to the groups will be spasmodic. Forward your
observations to the link on my web site to be sure that I will pick them up.

Signature

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

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

>> In what way was my web site instruction incomplete? It even includes
>> illustrations!
[quoted text clipped - 12 lines]
> possibly I'd missed a detail in the instruction you have on the site.
> I'll let you know.

Reply to this Message