Mail merge with text file but ignore info in speechmarks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hcoms - 02 Apr 2004 14:08 GMT

Hello,

I am mail merging with a text file that is seperated by commas. All the
fields that are in the mail merged text file are surrounded by speech marks
Within some of these fields ,e.g. i have an address field , commas can
appear within the speech marks.
For example "The Road, a village"
I would like for word to ignore the commas within the speechmarks. If not
the whole thing can go wrong!!

I am using Word 2000 but would like it to work in Word 97 and newer.

All the best

Graham

Reply to this Message

Graham Mayor - 02 Apr 2004 17:57 GMT

You need to change the comma field separator for something else - e.g. |

If the fields are separated with commas and speech marks e.g.
"Field1","Field2","Field3

then replace "," with "|"

to give

"Field1"|"Field2"|"Field3

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hello,
>
[quoted text clipped - 11 lines]
>
> Graham

Reply to this Message