mail merge

[djchapple]

I am totally new to Access and this is my first database.

I have a database for volunteers in which table A is basically a calendar and table B a list of volunteers with their details.

What I want to do is construct a report that will allow me to produce a mail merge letter such that:

1. One volunteer, with his/her information, is selected from table B and inserted into a mail merge letter. (The volunteer selected will change from letter to letter).

2 Certain days are selected from table A and added to the mail merge letter. This information will be the same in all letter.

I have posted a separate thread asking how I can make the selection of days in (2) above so you can assume that I know how to make the selection within table B.

How do I proceed?

If anyone knows a good example of this type of report then i will be extremely grateful.

 

[Sergeant]

A mail merge might not be the best approach for this, for one reason:
The native mail merge functionality in Word does not do "grouping" for you. It's going to print a letter for each row in the query, even if the name is repeated for additional records in the calendar table. Maybe it's just me, but I don't know of a way to group all the matching records from table A under the table A info using a mail merge.
I think I would approach this with an Access report. You just need to play with the sorting and grouping to get one person on each page, with their relevant volunteer dates listed below.

 

[Matrix_zero]

Did u check peterssoftware?

Peterssoftware has a nice add on program, check it out.
Looks Nice... http://www.peterssoftware.com/lm.htm

Let me know if u try it and how it goes.

 

[djchapple]

Thanks for the help.

I have looked at the link given by Matrix_zero and its very good but it cannot be used in this case as the database will be used by several people all using computers with only MS Office Software.

Best wishes to you all for the New Year.