G Guest Sep 15, 2007 #1 How do I maintain (or permanently convert to text) formatted cells from Excel when using it with a Mail Merge in Word?
How do I maintain (or permanently convert to text) formatted cells from Excel when using it with a Mail Merge in Word?
D Dave Peterson Sep 15, 2007 #3 You can also format the values when you do the mail merge. Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: 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 about half way down the page.
You can also format the values when you do the mail merge. Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: 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 about half way down the page.
