Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
RJR RJR is offline
external usenet poster
 
Posts: 2
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Word 2003 Formatting merged fields GusEvans Mailmerge 6 February 11th 07 11:11 PM
Blank date fields in Excel merging with Date/Time margaret Mailmerge 1 March 16th 06 04:36 PM
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
long date formatting in access shows as short date in word farley Mailmerge 3 August 16th 05 04:45 AM
Formatting Date fields Greg Mailmerge 7 April 10th 05 12:27 AM


All times are GMT +1. The time now is 06:44 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"