+ Reply to Thread
Results 1 to 2 of 2

Insert hyperlink to file in vba generated email?

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    MD
    MS-Off Ver
    2018
    Posts
    19

    Insert hyperlink to file in vba generated email?

    Hello,

    I am trying to figure out how to insert a link to an excel file in an email generated by vba. The hyperlink will be a folder path not a URL. See the code below. This hyperlink will show up in the spot labeled HYPERLINK below represented by the name "order sheet"

    Dim OutlookApp As Object
    Dim OutlookMail As Object
    Set OutlookApp = CreateObject("Outlook.Application")
    Set OutlookMail = OutlookApp.CreateItem(0)
    On Error Resume Next
    With OutlookMail
    .To = Insert email
    .CC = ""
    .BCC = ""
    .Subject = "Order Request " & Date
    .Body = "You have recieved an order request from " & Initials.Value & ". Please see " & HYPERLINK & " for details"
    .Attachments
    .Send
    End With
    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
    Last edited by skhan5427; 11-09-2020 at 04:51 PM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Insert hyperlink to file in vba generated email?

    you said:
    Quote Originally Posted by skhan5427 View Post
    I am trying to figure out how to insert a link to an excel file in an email generated by vba.
    link TO an excel file? I think you meant how to insert a link SOURCED FROM an excel file, right? the link is in the book, and you want to PULL it and put it in the email? that's what it looks like, from this line alone:
    Please Login or Register  to view this content.

+ 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. Hyperlink into body of hyperlink generated email
    By jamievo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2020, 01:32 PM
  2. how to insert a hyperlink in an email generated using VBA?
    By mekha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2014, 02:24 PM
  3. [SOLVED] Making a filepath a hyperlink in an email generated with code
    By MissDB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-17-2014, 07:33 AM
  4. Insert CONCATENATE-generated file path into IF formula
    By feclips in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 04:35 AM
  5. [SOLVED] Insert Hyperlink And Send Email
    By Shahid_Excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2012, 09:49 AM
  6. Adding A Hyperlink To Excel Generated Email
    By WJO in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-13-2012, 04:29 PM
  7. embedding user-defined hyperlink into auto-generated email
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2008, 10:49 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