ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro that sends email with attachment and address (https://www.excelbanter.com/excel-programming/306845-macro-sends-email-attachment-address.html)

thebonython

macro that sends email with attachment and address
 
Hi,

Can anyone tell me if it's possible to create a macro that creates an
email, with an attachment of the current file (the one with the macro
in), with the email already addressed and the subject filled in.

(I have worked out how to do the email with attachment as macro - and
how to create an email with address and subject using an
email/html/hyperlink - but not how to get these functions combined).

Thanks a bunch,

Tim


---
Message posted from http://www.ExcelForum.com/


TommyBoy

macro that sends email with attachment and address
 
thebonython < wrote:

Hi,

Can anyone tell me if it's possible to create a macro that creates an
email, with an attachment of the current file (the one with the macro
in), with the email already addressed and the subject filled in.

(I have worked out how to do the email with attachment as macro - and
how to create an email with address and subject using an
email/html/hyperlink - but not how to get these functions combined).

Thanks a bunch,

Tim


---
Message posted from http://www.ExcelForum.com/



this is a good resource
http://www.rondebruin.nl/


--

thebonython[_2_]

macro that sends email with attachment and address
 
Thanks - that's great!


---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com