VBA Code for Outlook Email with PDF Attachment

[HakunamaTadatada]

Morning all!

I have been searching for a way to write some code that will generate an email to a list of people, then have a box pop up to ask for the file attachment and then send. Since the list of people is fairly long, that piece is really what this code will help with, but I'm stumped on if the rest of this is possible.

Regards,
Lesley

 

[Trevor G]

Hi Lesley,

Is the list of names held within Excel and are they internal or external (where do you get their email address from is my question which column do they start in)

 

[HakunamaTadatada]

Hi Lesley,

Is the list of names held within Excel and are they internal or external (where do you get their email address from is my question which column do they start in)

This is not Excel related at all- I'm curious to know if a macro can be written in Outlook to generate an email to a list of people and prompt for a PDF attachment.