Excel with mail merge problem. Not sure if there is an answer to this

bonar2k

Board Regular
Joined
Dec 3, 2007
Messages
70
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
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,122,907
Messages
5,598,788
Members
414,259
Latest member
beetle12

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top