Could someone please give me a bit of a starting point? I want to send an email to each of a selected group of volunteers. I already have a query that selects the right people (those with a volunteer checklist of "waiver" more than a year old AND a volunteer time sheet less than a year old). I want to export for those people:

- name, email address (which I can do)

- date and location from the LATEST volunteer time sheet

- date and description from the LATEST volunteer checklist item with description "waiver"

I'm using the Export module and I can include the correct people by using my query. I can get name and email address in the output. However, for the volunteer timesheet and volunteer checklist items, it seems that I can get either all of the timesheets and checklist items, or else one of them (or two or three) which is (are) not necessarily the latest.

I see that in the Reports module there is something somewhat similar in that it shows the latest volunteer activity date. However, what I would like is to export an Excel file with the data fields listed above so that I can do a mail merge in Word to send a customized email message to each person.

Any starting points as to an approach and procedure (or a reference where to find same) would be very helpful!

Thanks,

Dave

(Volunteer at Habitat for Humanity Tucson)