Outlook VBA to Attach File to Current Email

BAlGaInTl

Well-known Member
Joined
May 7, 2003
Messages
1,082
Okay... I normally dabble with some Excel VBA, but now I've found something I want to do in Outlook.

We have a web application that generates an Outlook email and a PDF. However, due to security restrictions, the file is not allowed to be automatically attached to the email. This means that the user has to go after the fact and attach a specific file to the email based on the generated subject line. I want to automate this process based on the subject line (which includes the base of the filename) for the generated email.

I can find all kinds of code that creates a "new" email in Outlook and attaches a file, but I can't seem to modify it to attach a file to the current email.

Can anybody offer any help?

ETA:

It would need to read the subject line of the generated email and modify it slightly to attach the file.
 
Last edited:

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,214,919
Messages
6,122,259
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top