Create an Excel button to send a PDF file via email to a fixed address

[HobbsC]

Hi everyone, really hope someone can help me with a problem I am having with my business.

I have 3 files that are all templates and saved as PDF.
These need to be sent to a single email address.

My staff will enter a case ID into the excel sheet, this will then become the SUBJECT of the email, and depending on what button they click will send one of the 3 PDFs.

So...

>Enter Case ID< (This will form the subject of the email)

Button 1 - (Sends PDF File 1)

Button 2 - (Sends PDF File 2)

Button 3 - (Sends PDF File 3)

All to the same email address

I am very new to excel, but any help would be much appreciated. If s

[Leith Ross]

Hello HobbsC,

Welcome to the forum!

All three files can be sent to the same email using a single button.

1. What are the file names?
2. Where do the names come from: worksheet, another workbook?
3. Where is the email address: code block, worksheet cell?

[HobbsC]

Hello,

Thanks for the reply!

The names of each files will be:

InvalidCB
PartialSVS
B2BReject

The names of the files are set - they are documents stored in a local drive. They can be stored anywhere it doesnt matter.
The email address can be anywhere aswell... its a set internal email. It can be in a cell.. whatever is easiest!

TIA