how do I mail merge data from excel to word as formated?

[Guest]

I have a large excel document. I need the data to merge to word document
exactly as it is in the excel sheet. (I am missing $ signs, ending zeros,
and thousand separaters) I am in a bind and need to complete asap.

 

[Peo Sjoblom]

You would be much better off posting this in a Word newsgroup

http://word.mvps.org/FAQs/MailMerge/index.htm

 

[Gord Dibben]

lulu

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.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks so much, I have my answer now

lulu

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.


Gord Dibben MS Excel MVP