Stevieboy_uk
Established Member
Hi folks
Need to pick your brains. I have been asked to do a mail merge in Word using data from an Excel spreadsheet (something I have done many times). However, the difference is that rather than it just being name and address information from a single row I have been asked to put a list of products that the customer has purchased in the merge also.
At the moment the data is listed in the Excel sheet so for example there might be 10 rows of data for one customer that lists different products but has their name and address against each product as set out below:
Name Address1 Address2 Address3 Postcode Product Price
Smith 1 some street some town postcode TV £500
Smith 1 as above as above as above Radio £75
Smith 1 as above as above as above BluRay £300
etc.......
Overall there are around 1100 rows with around 60 different customers.
So does anyone know how I would add the data from the product and price column in a table lower down on the Word document (the name and address data would be like any other mail merge) or do I need to set out the data in a different format.
I am sure if I knew VB (as some of the suggestions in Google seem to offer) it would be pretty straight forwards but unfortunately it's not something I am familiar with.
Any help would be gratefully received.
Steve
Need to pick your brains. I have been asked to do a mail merge in Word using data from an Excel spreadsheet (something I have done many times). However, the difference is that rather than it just being name and address information from a single row I have been asked to put a list of products that the customer has purchased in the merge also.
At the moment the data is listed in the Excel sheet so for example there might be 10 rows of data for one customer that lists different products but has their name and address against each product as set out below:
Name Address1 Address2 Address3 Postcode Product Price
Smith 1 some street some town postcode TV £500
Smith 1 as above as above as above Radio £75
Smith 1 as above as above as above BluRay £300
etc.......
Overall there are around 1100 rows with around 60 different customers.
So does anyone know how I would add the data from the product and price column in a table lower down on the Word document (the name and address data would be like any other mail merge) or do I need to set out the data in a different format.
I am sure if I knew VB (as some of the suggestions in Google seem to offer) it would be pretty straight forwards but unfortunately it's not something I am familiar with.
Any help would be gratefully received.
Steve