![]() |
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. |
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