Attach opened to new email

[Ruca13]

Hello experts,

The scenario I am working on is the following:

• I receive an email with a pdf invoice from a supplier;
• I register the invoice in an excel file;
• If the invoice is ok, I send an email to the accountants, with the invoice attached, saying it is approved.

What I would like to do is, on the excel file, after registering the invoice, click a button that would automatically create an new email with the invoice attached. Is it possible to attach pdf files like this (and how)?

Please note that the pdf is not saved, simply opened.

Thank you for your help,

Rui

 

[pbornemeier]

If you close the invoice the email it is in is still open and can be forwarded to the accountants with a comment in the forward portion of your email. Forwarded emails still have the attachments with which they were received.
Since the .pdf was not opened via VBA, VBA cannot (afaik) manipulate it. Once it is closed forwarding it is most likely discussed at this website: https://www.rondebruin.nl/win/s1/outlook/mail.htm.

You can also probably use code from that site to scan your inbox for email with attachments that meet certain criteria, then open them, solicit a response from you, which could update your excel register file (or not) and forward it (or not) based on your answer.