Date Format Conversion(Calculation)/Mail Merge "first Monday of Given Month"

[Ben]

I have a list of clients in an Access database. Each client has a meeting
that takes place on a specific day of a given month each year: e.g., "second
Monday in July." I am creating a Mail Merge in Word from this database. I
need to have "second Monday in July" merge as "July 12, 2004" this year and
be able to merge as "July 11, 2005" next year, etc. I am teaching myself
Access, and Mail Merge (with IF/THEN functions), and have a very limited
understanding of VB and Access. Please dumb down any explanation for me.



Thank you.

 

[Cindy M -WordMVP-]

Hi Ben,

I have a list of clients in an Access database. Each client has a meeting
that takes place on a specific day of a given month each year: e.g., "second
Monday in July." I am creating a Mail Merge in Word from this database. I
need to have "second Monday in July" merge as "July 12, 2004" this year and
be able to merge as "July 11, 2005" next year, etc. I am teaching myself
Access, and Mail Merge (with IF/THEN functions), and have a very limited
understanding of VB and Access. Please dumb down any explanation for me.

I'd say you need to take this question to an ACCESS newsgroup. What you'd need
to do is program a function in Access VBA that does this calculation for you.
Use the function in a QUERY EXPRESSION, then link to this query as the mail
merge data source. The query expression will show up as a field in the mail
merge.

Note that for this to work, you must link to the data source using DDE, which
means a few extra steps if you're using Word 2002/2003 (see that section in my
website's mail merge FAQ).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail