Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Patty Patty is offline
external usenet poster
 
Posts: 31
Default How do I mail merge data that contains double quotes (ie, 5'9")?

I am doing mail merge where the data is delimited by pipes (|). All works
fine, except occasionally the data contains double quotes (ie, 5'9") and Word
thinks that the double quote is a delimiter rather than just part of the
data. I need to keep the double quotes, but can't find a way to get Word to
ignore them. Any help?

FYI - I have tried placing double quotes and single quotes around the data,
but neither work.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I mail merge data that contains double quotes (ie, 5'9")?

FYI - I have tried placing double quotes and single quotes around the
data,
but neither work.


If you can,
a. double up the double quotes, i.e. change 5'9" to 5'9""
b. if necessary, place double quotes around the data /as well/

Otherwise, an alternative may be to replace all double-quote characters in
the data by two single quotes (which generally look identical in Word)

Peter Jamieson




"Patty" wrote in message
...
I am doing mail merge where the data is delimited by pipes (|). All works
fine, except occasionally the data contains double quotes (ie, 5'9") and
Word
thinks that the double quote is a delimiter rather than just part of the
data. I need to keep the double quotes, but can't find a way to get Word
to
ignore them. Any help?

FYI - I have tried placing double quotes and single quotes around the
data,
but neither work.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Mail Merge Data Question Tom Bean Mailmerge 7 May 26th 06 12:02 AM
Word 2000 mail merge documents won't save Access 2000 data source Andy C Mailmerge 1 May 17th 06 08:39 AM
How do I create a read-only mail merge data source? Julie Mailmerge 3 November 16th 05 07:23 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM


All times are GMT +1. The time now is 03:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"