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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |