+ Reply to Thread
Results 1 to 7 of 7

Hyperlinks:to an e-mail address

  1. #1
    Registered User
    Join Date
    11-07-2006
    Posts
    22

    Hyperlinks:to an e-mail address

    Hello,

    Within my worksheet I have a hyperlink to an e-mail address. I need for that hyperlink to not only open an e-mail, but send the worksheet as an attachment automatically. Is this feasible?

    Thank You

  2. #2
    Registered User
    Join Date
    11-07-2006
    Posts
    22

    automatically submit and send to a specific e-mail address

    How can I create a macro in order for my spreadsheet to automatically submit and send to a specific e-mail address?

    Help please!!

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    This link may help

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

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Registered User
    Join Date
    11-07-2006
    Posts
    22

    Moderator

    Thanks. This is all new to me, so how do I apply the code to make this work?

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Instructions on site.

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

    If you need more help may I sugguest you provide more details and prehaps and example and someone may be able to assist you further

    VBA Noob

  6. #6
    mpeplow
    Guest
    I could never get the email thing to work right, but it is possible, I'm just picky on the way I want it to work.

    I would start here, hope this helps a bit.

    http://www.ozgrid.com/VBA/send-email.htm
    http://j-walk.com/ss/excel/tips/tip86.htm

  7. #7
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    With the code below you can mail the current file :

    Please Login or Register  to view this content.
    Succes.

    Erik

+ 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