Amber,
It is the format of the merged field in MS Word document that is important,
not the Excel file.
Here is some stuff from Word's help file.
HTH
Regards,
Kevin
Format merged data <<<<~~~~You might want to search for this on your version
of Word
To format merged data, you must format the merge fields in the main
document. Don't format the data in the data source, because its formatting
isn't retained when you merge the data into the document.
Make sure you've already set up the main document, selected a data source,
and inserted merge fields in the main document.
Learn about setting up a mail merge.
9In the main document, click the merge field that corresponds to the data
you want to format.
On the Format menu, click Font, and then select the options you want.
Tips
If you're creating envelopes, you can also choose the delivery address font
while you're setting options on the Envelope Options tab during the mail
merge. Or if you want to change the delivery address font for all envelopes
you create that are based on the current template, you can modify the
Envelope Address style.
To control other aspects of formatting, press ALT+F9 to display field codes,
and then add switches to the merge fields. For example, to display the
number "34987.89" as "$34,987.89," add the Numeric Picture switch (\#). To
print client names in uppercase letters, add the Format switch (\*). To
ensure that the merged information has the same font and point size you
apply to the merge field, you can add the \* Charformat switch.
Amber said:
When I merge my excel info into my word document the date is automatically
reformatted to dd/mm/yy. I have it formatted as Wednesday, October 29, 2003
(ie). How do I get the information to merge exactly as is into my letter.
I am getting a headache trying tofigure it out. It looks right in my
document but merges wrong. I tried to confirm conversion at set up and
click DDE etc...and I can't establish a connection. Is there another way
around this that I am missing?
