Mail Merge

[ianspaul]

When I mail merge using excel and word 2007 the format I use for the numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

 

[Bernard Liengme]

See http://office.microsoft.com/en-ca/word/HA011164951033.aspx
It does not mention Office 2007 but the methods apply
More at
http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm
http://word.mvps.org/FAQS/MailMerge/CreateADataSource.htm

best wishes

 

[Bernard Liengme]

Some more
Force Word to use the number format you want
http://homepage.swissonline.ch/cindymeister/mergfaq.htm

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

 

[ianspaul]

Thanks for your help. This does not seem to work with 2007. I'm sure it
should be simple but maybe I'm missing something.