+ Reply to Thread
Results 1 to 2 of 2

How to attach an excel workbook to an email using a hyperlink?

  1. #1
    Wk
    Guest

    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.

  2. #2
    Damon Longworth
    Guest

    Re: 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" <Wk@discussions.microsoft.com> wrote in message
    news:8429EBA2-0484-402B-848D-E1E9791A69F3@microsoft.com...
    >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.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1