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

 

[Gord Dibben]

Mailmerge does not recognise Excel formatting, just the real data.

You can convert the data in Excel to text values before merging.

See David McRitchie's site for how-to's

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Or Formatting can done at the Word end by formatting the fields the Excel
data is dropped into.


Gord Dibben MS Excel MVP

 

[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.