Word mail merge using Access. Formatting wrong.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble with a Word mail merge using Access as my data source. I
have Access set up to have dates in "long date" and time in "medium time".
When I merge to Word the fields show in "short date" and "long time". How do
I fix this? I want the Word document to read Thursday, September 9, 2004 and
the time to read 4:00 PM and so forth. It now reads as 9/9/04 and 4:00:00.
 
Just build a query, and force the format.

Drop in all the fields you want in your query. Now, add a column like:


MyLongDate:format([YourDateField],"DDDD, MMMM, DD, YYYY")

MyLongTime:format([YourTimeField],"HH:MM AM/PM")


Then base your mail merge on this query....

And, if you need something to build, and make word templates for you, give
my sample word merge a try from here:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Access only supplies the values of the Date Field (unless you use the
Format() function in a Calculated Field "DateText" in the Query you want to
use as the DataSource for the MailMerge).

Using Word, set the correct date format for the required MergeField and Word
will pick up the date values from Access and format them the way you want.

--
HTH
Van T. Dinh
MVP (Access)




Niddala100 said:
I am having trouble with a Word mail merge using Access as my data source. I
have Access set up to have dates in "long date" and time in "medium time".
When I merge to Word the fields show in "short date" and "long time". How do
I fix this? I want the Word document to read Thursday, September 9, 2004 and
the time to read 4:00 PM and so forth. It now reads as 9/9/04 and
Click to expand...
4:00:00.
 
Niddala100 said:
I am having trouble with a Word mail merge using Access as my data source.
I have Access set up to have dates in "long date" and time in "medium
time". When I merge to Word the fields show in "short date" and "long
time". How do I fix this? I want the Word document to read Thursday,
September 9, 2004 and the time to read 4:00 PM and so forth. It now reads
as 9/9/04 and 4:00:00.
Click to expand...

Word is displaying the data, so have word format it.
 
Back
Top