A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word mail merge using Access. Formatting wrong.



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2004, 01:45 AM
Niddala100
external usenet poster
 
Posts: n/a
Default Word mail merge using Access. Formatting wrong.

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.
  #2  
Old September 10th, 2004, 02:24 AM
Albert D. Kallal
external usenet poster
 
Posts: n/a
Default

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 he
http://www.attcanada.net/~kallal.msn.../msaccess.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


  #3  
Old September 10th, 2004, 02:25 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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.


  #4  
Old September 10th, 2004, 02:46 AM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

Niddala100 wrote:
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.


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

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a WORD document as a subreport or report with mail merge Bob Reynolds General Discussion 3 August 15th, 2004 07:59 PM
Mail Merge in Word 2002 Pam Mailmerge 0 August 5th, 2004 04:11 AM
Word 2002 Mail Merge with Access database Nancy Mailmerge 1 June 23rd, 2004 10:33 AM
How to run word and pass a mail merge values and fax it to the recipient Belinda Mailmerge 2 June 13th, 2004 12:49 AM
HELP!!! Using Mail Merge Wizard / Access v2002 [email protected] Mailmerge 1 May 21st, 2004 08:51 AM


All times are GMT +1. The time now is 04:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.