Link to home
Create AccountLog in
Avatar of duncanb7
duncanb7

asked on

send webpage in outllook VBA

Dear Experts,
I would like to send webpage inside the email to my client by VBA outlook 2003.
Now I just know how to send email in text format  as follow simple code attach

I mean Client will receive the email to view the webpage inside the email no need to
re-open IE or no need click the href link to view to view the web page



Please advise  and provide a little code for send web page through email sent in Outlook 2003  VBA

Duncan
Function sendmail()
Set app = CreateObject("outlook.application")
Set itm = app.CreateItem(0)
Application.DisplayAlerts = False

With itm
.Subject = "dail report"
.To = "duncanuk9@hotmail.com.hk"
.Body = "daily last report"
'.Display
.Send  End With
Set app = Nothing
Set itm = Nothing

End Function

Open in new window

Avatar of SiddharthRout
SiddharthRout
Flag of India image

Instead of .Body, you will have to use .HtmlBody :)

Can you give more details of this web page that you want to send?

Sid
Avatar of duncanb7
duncanb7

ASKER

For example, www.yahoo.com

.htmlbody="http:www.yahoo.com"

Is it correct ? But I fail, it just send the path of link
Oh so you want to show the entire "www.yahoo.com" webpage in the email?

Sid
Yes,
Any suggestion ? Please advise kindly
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
it works but some ISP email box could not display the wbepage , Why?

and if we can .htmlbody in VBA is same as your suggestion web site
I  use .htmlbody that is similar to .body , Why ?
>>>>it works but some ISP email box could not display the wbepage , Why?

Probably it is blocked by the system administrator?

>>>>I  use .htmlbody that is similar to .body , Why ?

I suggested .htmlbody for a different reason. I am not sure if you can use that here.

Sid
Thanks for your reply