Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oli merge oli merge is offline
external usenet poster
 
Posts: 15
Default mail merge currency symbols not working

Hello,

I am using Office 2000 (unfortunately) and trying to mail merge an excel
table to word. I have a column called 'CURRENCY' which contains either "£",
"US$" or "‚¬".

It is placed before a mail merge field called "AMOUNT" which is just a
number.

I have done this before successfully, but today I get "£"s appearing as "œ"
and "‚¬" as "?" although US$ is fine. I normally save the excel sheet as a csv
and it works. I have also tried saving as .xls but it makes no difference.

Please help, I dont want to change the Mail Merge at all since I must use it
as provided (so I CANT use if statements to format the AMOUNT field, I have
to use the CURRENCY field to denote which currency).

thanks,
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oli merge oli merge is offline
external usenet poster
 
Posts: 15
Default mail merge currency symbols not working

its ok i have found a way - if i save as "renewals.txt" (with the speech
marks) but actually choose .csv in the drop down box then it works.

for some reason.

"oli merge" wrote:

Hello,

I am using Office 2000 (unfortunately) and trying to mail merge an excel
table to word. I have a column called 'CURRENCY' which contains either "£",
"US$" or "‚¬".

It is placed before a mail merge field called "AMOUNT" which is just a
number.

I have done this before successfully, but today I get "£"s appearing as "œ"
and "‚¬" as "?" although US$ is fine. I normally save the excel sheet as a csv
and it works. I have also tried saving as .xls but it makes no difference.

Please help, I dont want to change the Mail Merge at all since I must use it
as provided (so I CANT use if statements to format the AMOUNT field, I have
to use the CURRENCY field to denote which currency).

thanks,

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
Mail Merge Currency Issue [email protected] Microsoft Word Help 2 February 24th 07 01:58 AM
Database Mail Merge with Currency! WendyMc Mailmerge 9 December 11th 06 04:48 PM
Currency in mail merge!! Jennifer Mailmerge 1 March 29th 06 04:59 AM
how do I print currency in mail merge doc? mathstar Mailmerge 3 October 23rd 05 06:12 AM
mail merge with currency Kelly Mailmerge 4 July 6th 05 01:05 AM


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