Macro/Script that pulls data and linked files as attachments into Outlook

[blarrabee]

I have a project tracker that contains data and links to files stored on OneDrive that I need to email to recipients in Outlook.

My current workflow is a cumbersome copy/paste from excel to outlook and then pull the necessary attachments together and email to the a set of recipients.

My thinking is that a script or macro could generate the email, and pull the attachments that I have hyperlinked to the excel doc.

Any suggestions welcome

EDIT: I'm using Excel for Mac 16.52

 

[earthworm]

I already have this macro with me which I developed recently . But for that you need the files to be stored in Computer and prepare complete list of receipts along with their email . Then i will customize as per your requirement and will share . You need to share sample data.