+ Reply to Thread
Results 1 to 3 of 3

Custom Button > E-mail. Hyperlink and text formatting question.

  1. #1
    Registered User
    Join Date
    12-25-2014
    Location
    Toronto, Ontario
    MS-Off Ver
    Outlook 2010
    Posts
    6

    Custom Button > E-mail. Hyperlink and text formatting question.

    Hello everyone,
    I'm creating a custom command button in my excel spreadsheet to open a new mail message window with recipients and a body of text.
    I have a couple of questions though. Could you help me answer them? I've been searching tirelessly on the internet and can't seem to find an answer

    1. Instead of an attachment action line, e.g. .Attachments.Add ActiveWorkbook.FullName,(which only attaches the document to your e-mail) can I attach a hyperlink of the actual current document? I assume it'd have to be saved on the harddrive obviously.
    2. I noticed when I click on my command button, the e-mail is in plain text. Is there a way I can change the font and size of the text in the body of the e-mail?

    Here is the code I am currently using:

    Please Login or Register  to view this content.
    Thank you everyone for taking the time to read this post.
    I've learned a lot reading through many of the posted discussions (but I haven't figured this out yet ;p )

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Custom Button > E-mail. Hyperlink and text formatting question.

    If you attach a hyperlink then the file would need to be saved on the net or a server that everyone receiving the mail has access to.

    To include a hyperlink though, you just need to write the link into the Body
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    12-25-2014
    Location
    Toronto, Ontario
    MS-Off Ver
    Outlook 2010
    Posts
    6

    Re: Custom Button > E-mail. Hyperlink and text formatting question.

    Thank you for your response.

    If you attach a hyperlink then the file would need to be saved on the net or a server that everyone receiving the mail has access to.
    This is the case. The file is saved on a network everyone is connected to.

    To include a hyperlink though, you just need to write the link in the Body
    Can this somehow be added automatically using VBA?

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add hyperlink to Outlook mail with variable text
    By askpcguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2014, 07:31 PM
  2. Can A Custom Command Button Have A Macro AND Hyperlink Assigned To It
    By fdegree in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2012, 07:43 PM
  3. Custom Tool Bar Button Question XP
    By Ray Batig in forum Excel General
    Replies: 1
    Last Post: 02-17-2006, 08:30 PM
  4. [SOLVED] Custom Button Question
    By Ray Batig in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 01:03 AM
  5. How can I make a custom button in one Excel form to e-mail easily.
    By Katydid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2005, 03:06 PM

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