How to merge dates into labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

katwhit - 23 Dec 2005 14:40 GMT

I have set up an excel data file with dates only. Each cell is formatted to
show, one date. The cells are formatted to show the dates in consecutive
order. The dates are fromatted and appear as follows: Monday, January 2, 2006
Tuesday, January 3, 2006 etc. However, when I use the Word 2003 mail
merge, and say to print labels, the dates are showing only as 01/02/06
01/03/06 etc. How do I correct this? What am I doing wrong?

Thank you for any help. It is greatly appreciated.
And Merry Christmas !!!

Signature

katwhit

Reply to this Message

Graham Mayor - 23 Dec 2005 15:06 GMT

You are not doing anything wrong. Word ignores the Excel formatting. You'll
have to add the formatting in Word - see
http://www.gmayor.com/formatting_word_fields.htm

Select the field in the first label right click and toggle to show

{Mergefield datefieldname}

add the switch \@ "dddd, MMMM d, yyyy"

{Mergefield datefieldname \@ "dddd, MMMM d, yyyy"}

F9 to update then if necessary toggle back again. Then propagate the labels
to carry the changes to the other labels

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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

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

> I have set up an excel data file with dates only. Each cell is
> formatted to show, one date. The cells are formatted to show the
[quoted text clipped - 6 lines]
> Thank you for any help. It is greatly appreciated.
> And Merry Christmas !!!

Reply to this Message