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

AssetName	Driver email	Manager email1	Manager email2	Manager email3	Manager email4	Manager email5	CCd	My email	Report name
NAME 10	name1@company1.com	name@hotmail.com	name2@company1.com	name3@company1.com			name4@company1.com	Email2@company1.com	Report (NEW) - NAME 10- August 2019 Driver Conversation Report
NAME 11	name1@company1.com	name@hotmail.com		name2@company1.com		name3@company1.com	name4@company1.com	Email2@company1.com	Report (NEW) - NAME 11- August 2019 Driver Conversation Report
NAME 12	name1@company1.com	name@hotmail.com		name2@company1.com			name4@company1.com	Email2@company1.com	Report (NEW) - NAME 12- August 2019 Driver Conversation Report
NAME 13	name1@company1.com	name@hotmail.com			name2@company1.com		name4@company1.com	Email2@company1.com	Report (NEW) - NAME 13- August 2019 Driver Conversation Report
NAME 14	name1@company1.com	name@hotmail.com			name3@company1.com	name2@company1.com	name4@company1.com	Email2@company1.com	Report (NEW) - NAME 14- August 2019 Driver Conversation Report

<tbody>
</tbody>

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.