I use this function every week. First I set the parameters for my query and save the query. Next, I open MS word, type my letter and then use mail merge and select my saved query as the database. You can then insert fields (which are named the same as those in your query).
good luck!
Thanks for your reply. I did try your advice however, when I ran the query, I had no results so, I am sure that I am just not getting it.
In the criteria for the "Birthay:Month([Date]" field, I did set the criteria as "Month(Date)". I wasn't sure if I was supposed replace...
I have an employee db and one field is employee birthdates entered in the following format: 05/10/1955, etc.
At the beginning of each month, I would like to run a report for employees who are celebrating birthdays for that month.
Being the "unconsummate" professional, I have been...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.