Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,226
- Office Version
- 365
- Platform
- Windows
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
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