How to send several rows of data from one column to each recipient in one go

[mikustykus]

Hi all,

I have been trying for a while to find a solution to this and it is driving me mad. I have been tasked with emailing everybody on our access database with the list of training they have attended in order to request evaluation. Now there's no way I want to do that manually 800 times, so I figure they must me a more efficient way of doing this.

My query gives me a table something like this:
Name , email , training event
p1, e1, te1
p1, e1, te2


p1, e1, te3
p2, e2, te2
p2, e2, te3
p2, e2, te5
p3, e,3 te2
p3, e,3 te4
p3, e,3 te5

Now obviously I could do a standard mail / email merge, but that would mean each person receives an email for every event they attended, and as some have done 10+ this would irritating and inconvenient.

What I would like to be able to do is send, for example, all three events - te1, te2, te3 (either on one line or a vertical list would be fine, but preferably vertical list) that p1 has done in one email to e1.

Is this going to be possible??

Many thanks for any help or suggestions.

Mikey