Email multiple reports to specific addresses

[Noddy13]

Hello,

I need to email out a list of individual reports to specific addresses.

The reports are located in C:reports and all have the same naming convention. Below is an eg of the spreadsheet and the data.

Paste starts from A1

[TABLE="width: 2751"]
<tbody>[TR]
[TD]AssetName[/TD]
[TD]Driver email[/TD]
[TD]Manager email1[/TD]
[TD]Manager email2[/TD]
[TD]Manager email3[/TD]
[TD]Manager email4[/TD]
[TD]Manager email5[/TD]
[TD]CCd[/TD]
[TD]My email[/TD]
[TD]Report name[/TD]
[/TR]
[TR]
[TD]NAME 10[/TD]
[TD]name1@company1.com[/TD]
[TD]name@hotmail.com[/TD]
[TD]name2@company1.com[/TD]
[TD]name3@company1.com[/TD]
[TD][/TD]
[TD][/TD]
[TD]name4@company1.com[/TD]
[TD]Email2@company1.com[/TD]
[TD]Report (NEW) - NAME 10- August 2019 Driver Conversation Report[/TD]
[/TR]
[TR]
[TD]NAME 11[/TD]
[TD]name1@company1.com[/TD]
[TD]name@hotmail.com[/TD]
[TD][/TD]
[TD]name2@company1.com[/TD]
[TD][/TD]
[TD]name3@company1.com[/TD]
[TD]name4@company1.com[/TD]
[TD]Email2@company1.com[/TD]
[TD]Report (NEW) - NAME 11- August 2019 Driver Conversation Report[/TD]
[/TR]
[TR]
[TD]NAME 12[/TD]
[TD]name1@company1.com[/TD]
[TD]name@hotmail.com[/TD]
[TD][/TD]
[TD]name2@company1.com[/TD]
[TD][/TD]
[TD][/TD]
[TD]name4@company1.com[/TD]
[TD]Email2@company1.com[/TD]
[TD]Report (NEW) - NAME 12- August 2019 Driver Conversation Report[/TD]
[/TR]
[TR]
[TD]NAME 13[/TD]
[TD]name1@company1.com[/TD]
[TD]name@hotmail.com[/TD]
[TD][/TD]
[TD][/TD]
[TD]name2@company1.com[/TD]
[TD][/TD]
[TD]name4@company1.com[/TD]
[TD]Email2@company1.com[/TD]
[TD]Report (NEW) - NAME 13- August 2019 Driver Conversation Report[/TD]
[/TR]
[TR]
[TD]NAME 14[/TD]
[TD]name1@company1.com[/TD]
[TD]name@hotmail.com[/TD]
[TD][/TD]
[TD][/TD]
[TD]name3@company1.com[/TD]
[TD]name2@company1.com[/TD]
[TD]name4@company1.com[/TD]
[TD]Email2@company1.com[/TD]
[TD]Report (NEW) - NAME 14- August 2019 Driver Conversation Report[/TD]
[/TR]
</tbody>[/TABLE]

I am OK at inserting the subject and text into the macro for the email but am struggling working out how to reference each report against all of the required emails addresses.

TIA

 

[Rijnsent]

Hi Noddy,
could you please post the code you created, that makes helping you a lot easier.
Thanks,
Koen

 

[Noddy13]

Hello Koen,

I have given up on the code and moved to a formula as this now looks like a one off exercise rather than an one going one as first thought. I am having issues with it though. I have come up with

=HYPERLINK("mailto:"&B2&";"&C2&";"&D2&";"&E2&";"&F2&";"&G2&"?subject="&L2&"-"&A2&"&Body="&L2&"-"&A2&"%0A%0A"&L3&"",A2)

Where B2:G2 and email addresses, A2 is text and L2:L8 and also text. I get the #value error when I try to add any more to the formula.