Reply
 
Thread Tools Display Modes
  #1   Report Post  
LindaM
 
Posts: n/a
Default Mailmerge with Access - character change

We produce a monthly report in Word, using data from an Access dbase, usually
with no problems. Since last month we have changed Pounds to Euros in the
dbase, but Word continues to insert £ instead of ‚¬. We can find no trace of £
anywhere in the dbase or in the Word macros we use for formatting Any idea
what's happening and how to stop it?
--
Linda M
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?TGluZGFN?=,

We produce a monthly report in Word, using data from an Access dbase, usually
with no problems. Since last month we have changed Pounds to Euros in the
dbase, but Word continues to insert £ instead of ‚¬. We can find no trace of £
anywhere in the dbase or in the Word macros we use for formatting Any idea
what's happening and how to stop it?

You should really post this in the word.mailmerge.fields newsgroup, where your more
likely to encounter people who deal with this (and a much lower volume of messages,
so it's more likely to be seen). WHen you repost there, be sure to mention the
VERSION of Word and of Access you use.

My best guess would be that the connection method you're using to pass the data from
Access to Word doesn't recognize Unicode symbols in this range. The other
possibility, if you're still seeing £, is that there are number formats in the merge
fields. Press Alt+F9 in the main merge document and check if there aren't £ symbols
in the field codes that are normally hidden.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)

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
Mailmerge Access record duplication problem..Deadline Help ASAP Pl Paul Mailmerge 1 February 14th 05 11:12 PM
Mailmerge from VB to WORD 2002 with Access [email protected] Mailmerge 5 February 7th 05 05:16 PM
Access to Word Mail Merge; symbols change to question marks Rob S. Mailmerge 1 January 17th 05 12:25 PM
MailMerge Word 2003 to Access 2000 query blank data BCool Mailmerge 1 January 15th 05 12:31 AM
Mailmerge data source in an Access database will not open Colin C Mailmerge 3 December 31st 04 12:01 AM


All times are GMT +1. The time now is 05:37 PM.

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"