Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
converting 3/3/06 in msaccess to March 3, 2006 in word via mailmer
I use office professional 2000. Dates in access appear as i.e. 3/3/06.
Merging results in same appearance in Word. In access, I formatted dates as mmmm d yyyy which resulted in March 3, 2006 appearing in access. Yet when I merge into a word document, the date returns to 3/3/2006. I am not a programmer. If syntax is involved, kindly provide a sample. Sincerely Frustrated from NY |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
converting 3/3/06 in msaccess to March 3, 2006 in word via mailmer
You need to incorporate the appropriate formatting switches... formatting is
*not* carried over from the source. Something like; \@"MMMM dd, yyyy" \* MERGEFORMAT* Have a look here; http://www.gmayor.com/formatting_word_fields.htm HTH |:) "diros" wrote: I use office professional 2000. Dates in access appear as i.e. 3/3/06. Merging results in same appearance in Word. In access, I formatted dates as mmmm d yyyy which resulted in March 3, 2006 appearing in access. Yet when I merge into a word document, the date returns to 3/3/2006. I am not a programmer. If syntax is involved, kindly provide a sample. Sincerely Frustrated from NY |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
converting 3/3/06 in msaccess to March 3, 2006 in word via mailmer
Hi ?B?ZGlyb3M=?=,
I use office professional 2000. Dates in access appear as i.e. 3/3/06. Merging results in same appearance in Word. In access, I formatted dates as mmmm d yyyy which resulted in March 3, 2006 appearing in access. Yet when I merge into a word document, the date returns to 3/3/2006. I am not a programmer. If syntax is involved, kindly provide a sample. I normally wouldn't expect to see this in Office 2000, unless you're explicitly choosing ODBC as the connection method? Anyway, you basically have two choices, both of which are outlined in the Mail Merge FAQ on my website. One is to set the formatting picture in the merge field, in Word. Example: { Mergefield Date \@ "mmmm d, yyyy" } The other is to use the Format function in an Access query. MergeDate: Format([Date], "MMMM d, yyyy") Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hard space between words. | Microsoft Word Help | |||
Fill-in field prompts | New Users | |||
WP merge file to Word | Tables | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
How do I get rid of page numbers. The page number virus | Microsoft Word Help |