Formatting feild in mail merge

W

William5271

I have a date feild from an Access database that is in numerical format and I
would like to change it to a written format (January, 17th, 2005). How do I
re-format it without changing the original source?
 
A

Albert D. Kallal

Just base the merge on a query.

for the date field in the querybuidler, just go:



MyDate:format([DateFieldName,"MMMM, DD, YYYY")
 
W

William5271

How do I change data sources in the mail merge without having to start over
and re-assign each feild in my document?
 
A

Albert D. Kallal

William5271 said:
How do I change data sources in the mail merge without having to start
over
and re-assign each feild in my document?
Click to expand...


Hum, I thought the word wizard allowed you to just choose a different
source.....

Just open up the word document, and use the merge wizard again...it should
keep all of your existing fields.

You only added ONE extra field to the query....

All of the field names will be the same except for the one extra new date
field.....

So, keep all of the same fields (and field name) in the query, and just add
an additional column with the formatting as mentioned.

I actually never set the data source in my word merge documents, and have a
ms-access to word merge example
that I use here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
 
A

aaron.kempf

you can also do this on the mail merge (word) side of the equation

I had to do that extensively, when i was using Office Writer.

I mgiht be able to come up with a better example; let me know if you
absoultely need it.
I just don't know what in the heck i'd use as a keyword to find it in
my inbox; I know I would have emailwed that to myself
 
A

aaron.kempf

yeah; I looked in my email

yuo have to-- on the word side 'enable toggle codes' or something like
that; and then it's just a simple format mask

hope that helps; if I had something to search on I might be able to
find a better example

I had to do this 100 times just a couple of months ago; it shouldn't
be this hard for me to find stuff LoL
 
Top