Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a date field in mail merge
I am trying to use a date field in a mail merge of an Excel spreadsheet with a Word document. Every time I do the merge the date on the merge document comes out incorrectly. I have tried formatting the field in the spreadsheet as text and all kinds of date format but it never comes out in the merge document as I want it to be i.e. dd/mm/yy. Sometimes it does not even resemble a date but is complete rubbish. Any ideas would be most welcome. -- triciaodd ------------------------------------------------------------------------ triciaodd's Profile: http://www.excelforum.com/member.php...o&userid=30861 View this thread: http://www.excelforum.com/showthread...hreadid=505302 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a date field in mail merge
Debra Dalgleish posted this to a similar question:
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/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. triciaodd wrote: I am trying to use a date field in a mail merge of an Excel spreadsheet with a Word document. Every time I do the merge the date on the merge document comes out incorrectly. I have tried formatting the field in the spreadsheet as text and all kinds of date format but it never comes out in the merge document as I want it to be i.e. dd/mm/yy. Sometimes it does not even resemble a date but is complete rubbish. Any ideas would be most welcome. -- triciaodd ------------------------------------------------------------------------ triciaodd's Profile: http://www.excelforum.com/member.php...o&userid=30861 View this thread: http://www.excelforum.com/showthread...hreadid=505302 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to filter on a date field during mail merge | Excel Worksheet Functions | |||
Mail merge to word | Excel Discussion (Misc queries) | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |