Can't find the answer to this so here goes:
I am putting together a DB to register volunterers on an event using Access 2003.
The event will run for a number of days and volunteers may take up a number of different roles.
I have a volunteers details table
I have a Volunteersroles table ( these are linked using VolunteerID) and this has lookups for Days and Roles.
I would like to be able to send a bulk email so each individual will get a list of their allocated roles for each day.
I have no problem with basic email mail merge but can't see how to merge the roles data.
I see this much like have a report and sub report , the report being the volunteer details and the sub report the linked Volunteer roles.
How do I pass the Volunteer roles part to the merge?
Any help would be much appreciated.
I am putting together a DB to register volunterers on an event using Access 2003.
The event will run for a number of days and volunteers may take up a number of different roles.
I have a volunteers details table
I have a Volunteersroles table ( these are linked using VolunteerID) and this has lookups for Days and Roles.
I would like to be able to send a bulk email so each individual will get a list of their allocated roles for each day.
I have no problem with basic email mail merge but can't see how to merge the roles data.
I see this much like have a report and sub report , the report being the volunteer details and the sub report the linked Volunteer roles.
How do I pass the Volunteer roles part to the merge?
Any help would be much appreciated.
Last edited: