Using () in mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G-Man - 21 Jan 2005 02:55 GMT

I've got a financial-based Excel file that needs to keep the ()'s intact when
doing a mail merge in Word. I'm using Office 2003. It worked perfectly in
Office 97. Any ideas? I've read the external website
http://www.gmayor.com/formatting_word_fields.htm on using switches and this
might do the trick. I was curious to see if anyone had any other suggestions
to keep this formatting intact. Thanks!

Reply to this Message

Graham Mayor - 21 Jan 2005 05:49 GMT

Microsoft has changed the default way that Word connects to external data,
so Word is now expected to provide the formatting. My web link that you
referred to explains how to do this. An alternative is to use the earlier
method of connection and this explained at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm. However the former
solution is simpler.

Signature

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

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

> I've got a financial-based Excel file that needs to keep the ()'s
> intact when doing a mail merge in Word. I'm using Office 2003. It
> worked perfectly in Office 97. Any ideas? I've read the external
> website http://www.gmayor.com/formatting_word_fields.htm on using
> switches and this might do the trick. I was curious to see if anyone
> had any other suggestions to keep this formatting intact. Thanks!

Reply to this Message

G-Man - 07 Feb 2005 15:39 GMT

Your instructions worked flawlessly. Thanks for the response.

G

> Microsoft has changed the default way that Word connects to external data,
> so Word is now expected to provide the formatting. My web link that you
[quoted text clipped - 9 lines]
> > switches and this might do the trick. I was curious to see if anyone
> > had any other suggestions to keep this formatting intact. Thanks!

Reply to this Message

Rate this thread: