Mail Merge

[Skybluekid]

Hi

Is it possible to include a range of value from Excel, in a Mail Merge?

What I am after is, if I have a list of values belonging to one person, I would like to send that person a mail and in that Mail it would list all the values that belonged to that person.

Example data

Truck 1 Person 1
Truck 2 Person 1
Truck 3 Person 1
Truck 4 Person 2
Truck 5 Person 2
Truck 6 Person 3
Truck 7 Person 3
Truck 8 Person 3

In my mail merge, if person 1 was selected, in my mail merge, it would list all the Trucks associated with Person 1 i.e

Dear Person 1,

The following trucks are due for Service:

Truck 1
Truck 2
Truck 3

etc etc...


Hope this makes sense


Thanks in Advance

 

[Rijnsent]

Hi Skybluekid,

something like this link (a bit old, but I would guess it still works): Advanced Word 2003 Mail Merge: Combining Records | Cornell University

Koen