A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Reload this Page href in Outlook
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

href in Outlook


« Identify "Propose New Time" meeting responses in VBA, and how to response with them | OLE IDispatch exception code 4096 from Microsoft Office Outllok »

 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 7th 10, 02:46 PM
corquando corquando is offline
Junior Member
  
First recorded activity at Outlookbanter: Feb 2010
Posts: 7
Default href in Outlook
Greetings . . .

I have a slice of code wherein I'm atttempting to send emauils from a db of addresses, in a CDO environment.

Everything works just dandy excepth for the fact that the HTML link desired doesn't go through. All the text goes fine.

Without bothersonme details, here's a snippet:

Code:
                StrBod = " HTML "
                StrBod = StrBod & " HEAD/HEAD "
                StrBod = StrBod & " BODY "
                StrBod = StrBod & "Dear Valued People(s),  p  p "
                StrBod = StrBod & "You so rock p  p ""
                StrBod = StrBod & "Buy this stuff p  p ""
                StrBod = StrBod & "You'll love it p  p ""
                StrBod = StrBod & "Please click on the link below for  more information. p  p ""
                StrBod = StrBod & "Sincerely, p  p ""
                StrBod = StrBod & "Your Excellent Friends p  p "p"
                StrBod = StrBod & "a href = "" http://www.wxyz.com/and/so_forth/and/so_on.html="" + Link + """"   /a "
                StrBod = StrBod & " /BODY "
                StrBod = StrBod & " /HTML "


            With iMsg
                Set .Configuration = iConf
                .To = EML
                .CC = ""
                .BCC = ""
                .From = "
                .Subject = "Howdy, Folks"
                .HTMLBody = StrBod
               End With
(The odd spaces are to ensure no code execution - The HTML brackets are very shy . . .)

The body comes through but not the link.

Any idears?
Ads
  #2  
Old September 7th 10, 03:30 PM
corquando corquando is offline
Junior Member
  
First recorded activity at Outlookbanter: Feb 2010
Posts: 7
Default
Quote:
Originally Posted by corquando View Post
Greetings . . .

I have a slice of code wherein I'm atttempting to send emauils from a db of addresses, in a CDO environment.

Everything works just dandy excepth for the fact that the HTML link desired doesn't go through. All the text goes fine.

Without bothersonme details, here's a snippet:

Code:
                StrBod = " HTML "
                StrBod = StrBod & " HEAD/HEAD "
                StrBod = StrBod & " BODY "
                StrBod = StrBod & "Dear Valued People(s),  p  p "
                StrBod = StrBod & "You so rock p  p ""
                StrBod = StrBod & "Buy this stuff p  p ""
                StrBod = StrBod & "You'll love it p  p ""
                StrBod = StrBod & "Please click on the link below for  more information. p  p ""
                StrBod = StrBod & "Sincerely, p  p ""
                StrBod = StrBod & "Your Excellent Friends p  p "p"
                StrBod = StrBod & "a href = "" http://www.wxyz.com/and/so_forth/and/so_on.html="" + Link + """"   /a "
                StrBod = StrBod & " /BODY "
                StrBod = StrBod & " /HTML "


            With iMsg
                Set .Configuration = iConf
                .To = EML
                .CC = ""
                .BCC = ""
                .From = "
                .Subject = "Howdy, Folks"
                .HTMLBody = StrBod
               End With
(The odd spaces are to ensure no code execution - The HTML brackets are very shy . . .)

The body comes through but not the link.

Any idears?
I found the answer, so in case anybody wants to know . . .

The href statement is:
StrBod = StrBod & "{A href = http://www.wxyz.com/and/so_forth/and/so_on.html=}Link{/A} "

Odd brackets take the place of the HTML brackets, so exactness is maintained. No plusses or ampersands.

And there you have it. Works like a charm!
 



« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
href tags does not result in the full url with Redemption DPM Outlook and VBA 4 November 18th 09 06:35 AM
Desktop Alert display href content Firas Rashid Outlook - General Queries 2 February 21st 06 01:54 PM


All times are GMT +1. The time now is 05:03 PM.

Feed Icon - Contact Us - OutlookBanter Home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.