Organising Distribution List in Excel

Tom2017

New Member
Joined
Jan 20, 2017
Messages
2
Hi there

We have quite a complicated distribution list with emails of individuals/teams who need to receive emails about product sales. The list is stored in Excel. I wonder if there is a better way of organising it so that the email address can be easily copied and pasted into an email.

The way it works at the moment is that if we are sending a report from sale of apples it need to go to individuals and core lists. These two never change. Then relevant people are included in the email depending on sales channel, region, whether these were eco or no eco apples etc. So for a report about online sale of eco apples in Europe packaged in plastic bag the email distribution list will be different to the one for wholesale sale of non eco apples sold in cardboard boxes in Asia.

The list needs to be user friendly and also cater to the fact that some lists are longer and some shorter.

All suggestions are welcome.

Thank you
 

Attachments

  • Distrbution list.PNG
    Distrbution list.PNG
    30.5 KB · Views: 7

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,214,943
Messages
6,122,369
Members
449,080
Latest member
Armadillos

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
Back
Top