Hello
I have created a dashboard report that draws in various sources of information. This is tailored depending on the value selected in a dropdown (ie the lookups selection the appropriate information for that value). There are around 120 different options in the dropdown so in effect I have 120 different dashboard reports.
What I would like to do is produce a macro that cycles through each selection in the dropdown and sends an email to the relevant address for the value in the dropdown, with the dashboard report either included as an excel attachment or in the body of the email. The values in the dropdown are all people so I can have appropriate email address on the sheet somewhere.
I would also need to include some text at the top of the email, so if I selected Joe Bloggs in the dropdown would want the email to say:
"Dear Joe
Please find attached/below, the dashboard report for blah blah blah."
Again, I can include the correct name for the email somewhere on the active sheet or on a lookup sheet.
I have used VBA a bit either writing simple macros or looking up and copy/paste how to do more complicated things, but am stuck with this. I am pretty proficient in most non-VBA excel.
Any help that can be offered would be greatly appreciated.
Regards
Paul
I have created a dashboard report that draws in various sources of information. This is tailored depending on the value selected in a dropdown (ie the lookups selection the appropriate information for that value). There are around 120 different options in the dropdown so in effect I have 120 different dashboard reports.
What I would like to do is produce a macro that cycles through each selection in the dropdown and sends an email to the relevant address for the value in the dropdown, with the dashboard report either included as an excel attachment or in the body of the email. The values in the dropdown are all people so I can have appropriate email address on the sheet somewhere.
I would also need to include some text at the top of the email, so if I selected Joe Bloggs in the dropdown would want the email to say:
"Dear Joe
Please find attached/below, the dashboard report for blah blah blah."
Again, I can include the correct name for the email somewhere on the active sheet or on a lookup sheet.
I have used VBA a bit either writing simple macros or looking up and copy/paste how to do more complicated things, but am stuck with this. I am pretty proficient in most non-VBA excel.
Any help that can be offered would be greatly appreciated.
Regards
Paul
