How do I change Mail merge formatting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T Perry - 01 Jun 2006 20:03 GMT

This is a repeat of an earlier question, but for some reason, it wouldn't let
me reply to the previous question to clarify my question and now I can't find
it at all, so I'm re-asking the question...hopefully more clearly. I was
making some sales labels in Word with an Excel spreadsheet as my datasource.
I put today's date (6-1-06) on the label (not as a merge field) and when I
added merge fields and told it to "update all labels" under "replicate
labels", it changed my date to a numbering sequence. (6-1-07, 6-1-08, 6-1-09,
etc.) I want today's date to stay the same on all of the labels. How do I
fix this?

Reply to this Message

Doug Robbins - Word MVP - 01 Jun 2006 21:18 GMT

Try clicking Undo.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> This is a repeat of an earlier question, but for some reason, it wouldn't
> let
[quoted text clipped - 9 lines]
> etc.) I want today's date to stay the same on all of the labels. How do I
> fix this?

Reply to this Message

Graham Mayor - 02 Jun 2006 06:35 GMT

As Doug asked in the reply to your earlier question, how did you insert this
date? There is no mechanism that I know of in Word (up to version 2003) that
will turn a number entered as text (or a date field for that matter) into a
variable numbering sequence. Excel can do this however?

Signature

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

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

> This is a repeat of an earlier question, but for some reason, it
> wouldn't let me reply to the previous question to clarify my question
[quoted text clipped - 6 lines]
> etc.) I want today's date to stay the same on all of the labels. How
> do I fix this?

Reply to this Message

Rate this thread: