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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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,963
Messages
5,575,265
Members
412,653
Latest member
JyothiGrace
Top