Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
OU_MartynF OU_MartynF is offline
external usenet poster
 
Posts: 1
Default Characters being substituted after mailmerge

I have a .csv file used as the source document of a mailmerge. I am using
Word 2003.

In one of the fields (of the .csv file) I have a « character. When this is
merged to the document the character is substituted with ". Similarly, if I
have «« in the field it returns "" in the merged document.

Is this normal behaviour and if so is there a way to stop this substitution ?

Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Characters being substituted after mailmerge

I get similar problems here. It could be that Word is detecting the encoding
incorrectly. Here, I was able to fix it by checkingWord
Tools|Options|General|"Confirm conversion at open" then selecting either
OLEDB (it asks you for info about the file twice for some reason) or ODBC,
but
a. if you go the OLEDB route, the headings/delimiter dialog box pops up
each time you reopen the document
b. if there are other non-Windows character set characters in the file they
will probably be lost if you use ODBC

Peter Jamieson

"OU_MartynF" wrote in message
...
I have a .csv file used as the source document of a mailmerge. I am using
Word 2003.

In one of the fields (of the .csv file) I have a « character. When this
is
merged to the document the character is substituted with ". Similarly, if
I
have «« in the field it returns "" in the merged document.

Is this normal behaviour and if so is there a way to stop this
substitution ?

Thanks in advance.



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
Multiple Conditional Characters in Mailmerge Tim Whitley Mailmerge 2 April 23rd 06 08:24 PM
Weird characters (double question marks) in text Jan Fransen Microsoft Word Help 2 September 19th 05 05:17 PM
email address truncated to 24 characters with mailmerge to Lotus Notes pw Mailmerge 0 June 24th 05 01:47 PM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
International characters in mail merge sandra Mailmerge 1 December 23rd 04 05:42 AM


All times are GMT +1. The time now is 01: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"