Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in mail merge
Hi friends,
I use mail merge facility extensively. The common problem I find is that the date format from excel appears as numbers in the mail merged document and not as a date. Why does this happen? Pl help regards krishna |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in 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/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Sai Krishna wrote: Hi friends, I use mail merge facility extensively. The common problem I find is that the date format from excel appears as numbers in the mail merged document and not as a date. Why does this happen? Pl help regards krishna -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in mail merge
Hi,
this worked! Thanks a lot. regards Krishna "Dave Peterson" wrote: 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/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Sai Krishna wrote: Hi friends, I use mail merge facility extensively. The common problem I find is that the date format from excel appears as numbers in the mail merged document and not as a date. Why does this happen? Pl help regards krishna -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge date | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
Using a date field in mail merge | Excel Discussion (Misc queries) | |||
Using a date field in mail merge | Excel Discussion (Misc queries) | |||
How to filter on a date field during mail merge | Excel Worksheet Functions |