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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,025
Messages
5,835,008
Members
430,332
Latest member
Charly_Moon

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