Automatically sending a PDF via emal (in the background)

HomeTek

New Member
Joined
Jan 27, 2017
Messages
36
Office Version
  1. 365
Platform
  1. Windows
Morning all,

I have a macro button that when pressed creates a PDF of the worksheet and attaches this to email (Outlook).

However, is it possible that upon pressing this button there is a way that the email can be automatically sent in the background?

I'm not entirely sure if this is possible as surely this would mean some kind of coding required within Outlook itself rather than Excel? I have no idea but thought it was worth asking the questions so I can at least rule this idea out if need be rather than scratching my head trying to figure it out.

Thanks
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,108,814
Messages
5,525,050
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top