VBA for sending URL through LOTUS NOTE

Hi

I am invlove in a project to sending survey Mails to the list of clients Email id .
i have a list of Client Email ids in a excel sheet also i have a web URL links against each client email ids My work is that to send the URL to each client through lotus note so that client click on the URL and complete the Survey

My problem is that i am able to send the mail through lotus not with the help of VBA but problem is that i don't knw how to send the Web URL in Mail body in a hyper link format so tht USER can click on the Url and URL is open

Welcome to the forum.

There are two ways to get the address for a link. It depends on how the link was entered. Was it by =Hyperlink or by Ctrl+K? For these 2 methods, see: http://www.mrexcel.com/forum/showthread.php?t=359874

Did you want to send it with the Hyperlink text or just the address? You can attach an xls with you link(s) if you like.

Hi

For referenece i m attach the file in which i just put a example like i need to send the web link like www.google.com to client through lotus note so that user wen click on this link this will open.The code which i put is only send the link in a string format which is not open wen click on it

so plz help

Lotus requires that you be more formal with web addresses. In your case, you will need to use the web address or fix it in your code. e.g.

Please Login or Register  to view this content.

If you are using other addresses that should have the mailto or ftp prefix's, you will need to fix those accordingly.

Originally Posted by Kenneth Hobson

Lotus requires that you be more formal with web addresses. In your case, you will need to use the web address or fix it in your code. e.g.

Please Login or Register  to view this content.

If you are using other addresses that should have the mailto or ftp prefix's, you will need to fix those accordingly.

Hi
Thank for reply but wat i wanted is that wen mail send to client . client will able to direct click on the link which i send in mail body so that he not need to copy the link in browser to open the link

Did you try what I demonstrated? If you do as I demonstrated, it will work.

As I explained in the referenced thread, Lotus Notes makes it into a hyperlink when you send it "IF" you have a formal address.

From the code that you posted, I could not see where you added the http:// prefix as I detailed.

However, no fix will work if the user has their preference set to not use hotspots. They set or unset it in Lotus Notes: File > Preferences > User Preferences... > Basics > Additional Options > Mark Internet URLs (Http://....) into Hotspots > OK.