Macro to populate save & send email recipients using sheet names

**L plates** · 10-10-2013, 11:07 AM

Hi All,

I have a transaction listings workbook with multiple sheets that is created daily. The first sheet named “Master” is a constant while consecutive sheets are added based on which staff members made transactions that day and named using the email prefix for each users email address.

E.g. If a users email address is jbloggs@madeupmail.com – the sheet would be named “jbloggs”.

The names and quantities of users is variable from day to day. At the end of each day I would like to use a macro to save and send the workbook, naming it as today's date, saving to a specific directory location with a pre-determined email message that I have the option to edit before sending . The recipients would be populated from the names of the sheets within the workbook.

Many thanks in advance for any help with this.

Regards,
Dave

**Cl.Klink** · 10-10-2013, 11:12 AM

See http://www.rondebruin.nl

Regards...Cl.Klink

**L plates** · 10-25-2013, 06:44 AM

Hi Cl.Klink,

Firstly, sorry for the extremely late reply and secondly, many thanks for the link. The Ron de Bruin site is extremely useful (added to favourites) but I could not find anything that would help me directly with my requirements. After trawling everywhere for a solution I've decided to tackle it from a different angle.

Again, many thanks for your assistance here!

Regards,
Dave

**L plates** · 02-27-2015, 07:57 AM

In the end this was resolved by using the transaction listing names in the master sheet where data for the other sheet names was taken from, removed the duplicates, converted the names to email addresses and then included the email addresses in a range array.

Thanks those that contributed.

Regards,