VBA help: Send Outlook email attachments from an Excel list

waldez

New Member
Joined
Jun 14, 2019
Messages
2
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!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

waldez

New Member
Joined
Jun 14, 2019
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,481
Members
412,596
Latest member
nickthebizz
Top