VBA help: Send Outlook email attachments from an Excel list

[waldez]

Hi there!

I need some help to automate sending emails from Excel. In an Excel sheet, when a user selects from the drop down menu, a list of files (it's a list of the full path of the attachment. Ex: P:\Stuff\Things\Cookies.pdf) appears that are related to that item.

However, I want to build a feature where the user will input their email address in a certain cell, run a macro, and Excel will send an email with those attachments. Would anyone know how to build a macro to do that? Any help would be greatly appreciated!

 

[waldez]

To clarify, the user would follow this process:
1. User selects a specific item from a drop-down menu.
2. A list of files (with the full path) will appear in the same sheet somewhere below.
3. User enters an email address in a specific cell and runs a macro.
4. Excel sends an email to the email address specified in step 3, with all of the attachments as specified in step 2.