+ Reply to Thread
Results 1 to 2 of 2

sending network path in HTML email via VBA in Lotus Notes

  1. #1
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    sending network path in HTML email via VBA in Lotus Notes

    I've got most of this working, I can create an HTML email and have it automatically parse the body text for a network path (looking for "\\") and then replace it with <a href=file:///, etc.....however, the link that appears in created emails opens an Internet Explorer window rather than a Windows Explorer window.....and then defaults to the intranet home page. I need these links to open in Windows Explorer.

    I'm pretty sure it's the format of the <a href= html segment but I know bugger all about html. Anyone?


    Full code, important bit marked in blue, I've had to remove SQL statements and put a space into html codes to get this to post:

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: sending network path in HTML email via VBA in Lotus Notes

    For anyone else trying to do the same thing, the answer is that the correct format of the href portion of the html is:

    <p><a href='file:///" & UNCnetworkpath & "'>" & text to appear in the email & "</a></p>

+ 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. Excel macro for sending email using lotus notes
    By ABDULLAHHATMI in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2013, 07:33 AM
  2. Email HTML Hotspot from Lotus Notes - Initialize Help Needed
    By sparrowce in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2013, 09:50 AM
  3. HELP: Recode macro for sending email via lotus notes
    By sunilwadhwa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 02:11 PM
  4. Sending Email through Lotus Notes
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-09-2011, 08:12 AM
  5. Automate Lotus Notes email with HTML body from excel
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2010, 06:47 PM
  6. Sending Excel through email using Lotus Notes
    By mridzuan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-25-2007, 10:29 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