+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, Excel: Link to send current spreadsheet as attachment in Technical; I want to put a "click here to email" link at the bottom of a spreashsheet that will email the ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    Excel: Link to send current spreadsheet as attachment

    I want to put a "click here to email" link at the bottom of a spreashsheet that will email the current document.. How would I go about doing thaT?

  2. #2
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    Hyperlink for the Send to: button? Bit of VBS to place a control to do the same thing? Not really sure how it works but the user needs an existing mail client for either of those I think.

  3. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    Ive got the hyperlink opening up outlook and filling the To and subject field.. Its just having the excel as an attachment I cant do..

  4. #4
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    Is the hyperlink perhaps not going to the "send as attachment" control?

  5. #5

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    Quote Originally Posted by leco View Post
    Is the hyperlink perhaps not going to the "send as attachment" control?
    I dont know how to do that.. Could you step me through it please?

    Excel for me is flight simulater and doing some sums.. VBA is way out my depths ;p

  6. #6
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    Sorry as I said previously, I'm not too sure of VBA either. Just seems logical that the task should be able to be coded. Some time since I wrote any and that wasn't in Excel. However, I'll have a think over the weekend I like a challenge

  7. Thanks to leco from:

    RabbieBurns (13th August 2010)



SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Adding sound to an Excel spreadsheet
    By leco in forum Office Software
    Replies: 2
    Last Post: 22nd February 2010, 08:59 PM
  2. Replies: 2
    Last Post: 5th February 2010, 09:47 AM
  3. Word Search - Excel Spreadsheet
    By DaveP in forum Downloads
    Replies: 0
    Last Post: 23rd December 2009, 12:04 PM
  4. excel spreadsheet editable online
    By Uraken in forum Web Development
    Replies: 4
    Last Post: 21st November 2007, 05:23 PM
  5. Excel - Spreadsheet Manipulation
    By danIT in forum Windows
    Replies: 1
    Last Post: 3rd July 2007, 02:28 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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