Software

Ask something
Discussion Locked

Mail Merge - Using Date selection

0 helpful
3 replies

by sillycarissa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a birthdate field in my data source for a mail merge in MS Word 2000. Each month I would like to pull off a list of those with birthdate that month. The help topic talks about using a field code to select this but I do not understand when or how to enter the values. I need step by step instructions ... select this, click this,enter this. Please assume I have only two fields, Name and Birthdate (10/13/1957) and want to print just those with October dates in the format "Name October 13, 1957". Thanks

3 replies

by Member 23567752

I can only give advice on Word 97, but I assume the process is the same. Once you have a completed database and document, you need go into your query options. From here you will have a series of colums. The first will define your field to query (in your case the date field), the second is the type of query (eg equal to, greater than). Probably for ease just select equal to. I the last column enter your date text you want to match (must be exactly the same as the way you put it in the database).Now when you do a merge, Word will query the date field, and find every entry that exactly matched your requested text.

This discussion is closed to new replies.