ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to attach an excel workbook to an email using a hyperlink? (https://www.excelbanter.com/excel-discussion-misc-queries/66285-how-attach-excel-workbook-email-using-hyperlink.html)

Wk

How to attach an excel workbook to an email using a hyperlink?
 
I have created a hyperlink in Excel that links to email (where the email
address and subject line are automatically filled out). I now want the Excel
workbook to be attached as an attachment to this email. How can I do this?
I tried using a macro, but it doesn't seem to work (my knowledge of macros is
very, very limited).

Thanks.

Damon Longworth

How to attach an excel workbook to an email using a hyperlink?
 
Have a look here for code samples using VBA:

http://www.rondebruin.nl/sendmail.htm

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21th, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England


"Wk" wrote in message
...
I have created a hyperlink in Excel that links to email (where the email
address and subject line are automatically filled out). I now want the
Excel
workbook to be attached as an attachment to this email. How can I do
this?
I tried using a macro, but it doesn't seem to work (my knowledge of macros
is
very, very limited).

Thanks.





All times are GMT +1. The time now is 02:44 PM.

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