Hi, I need to create a mail merge letter to send out to say 250 recipients, the spreadsheet goes from say A1:HR250 and is built like the example below.
I want to be able to send out a mail merge letter but I don't want to have all the fields where the spreadsheet does not have a value.
So 1 customer may be charged for 20 things and another is charged for 30 different things, I don't want to include all the column heading for items where they haven't had that service.
So in short is there anything I can do in excel so that the letter going out to the customers only shows lines of amounts applicable to them.
I hope that this makes sense, thanks for even looking at this post.
For example
A1 = Name
A2 = Mr Smith
A3 = Mr Jones
A4 = Mr Brown
etc
etc
etc.
B1 = Address
B2 = 1 Any Street
B3 = 35 Letsbee Avenue
B4 = 10A Baker Street
C1 = Renew Door
C2 = $30
C3 = 0
C4 = 0
D1 = Cut Grass
D2 = $50
D3 = 0
D4 = 0
I want to be able to send out a mail merge letter but I don't want to have all the fields where the spreadsheet does not have a value.
So 1 customer may be charged for 20 things and another is charged for 30 different things, I don't want to include all the column heading for items where they haven't had that service.
So in short is there anything I can do in excel so that the letter going out to the customers only shows lines of amounts applicable to them.
I hope that this makes sense, thanks for even looking at this post.
For example
A1 = Name
A2 = Mr Smith
A3 = Mr Jones
A4 = Mr Brown
etc
etc
etc.
B1 = Address
B2 = 1 Any Street
B3 = 35 Letsbee Avenue
B4 = 10A Baker Street
C1 = Renew Door
C2 = $30
C3 = 0
C4 = 0
D1 = Cut Grass
D2 = $50
D3 = 0
D4 = 0
