Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting of merged fields for date and times doesn't work with E
Hello,
I have a several WORD merge files that use Excel as my data source. I have the following merge fields in the body of the letter. ". I will meet you at your establishment on 39142 at 0.53125. Please have the following information available for my review:" I have used alt-F9 and the merge field looks like this. { MERGEFIELD "L01_Visit_Date"\@ "Dddd, Mmmm dd, yyyy" } and {MERGEFIELD "L01_Visit_Time"\@ "hh:mm am/pm"}. Is thjere something that I'm missing to get the format correct? This same problem is apparant with all my merge documents. How can I make these display correctly. Any help is appreciated. I am using a macro in Excell to do the opening and finding of the database, BUT the behavior is the same with or without the code opening or closing the case. The particular field in EXCEL 2003 is formatted as date and hour and they work fine in EXCEL. Would making that field a "Text" field work, or would that just bring the numbers over too. Thanks in advance. Bob Reynolds |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Word 2003 Formatting merged fields | Mailmerge | |||
Blank date fields in Excel merging with Date/Time | Mailmerge | |||
IF then with merged date field from excel | Mailmerge | |||
long date formatting in access shows as short date in word | Mailmerge | |||
Formatting Date fields | Mailmerge |