HomeTek
New Member
- Joined
- Jan 27, 2017
- Messages
- 42
- Office Version
- 365
- Platform
- 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
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