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
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
ASKER
For example, www.yahoo.com
.htmlbody="http:www.yahoo.com"
Is it correct ? But I fail, it just send the path of link
.htmlbody="http:www.yahoo.com"
Is it correct ? But I fail, it just send the path of link
ASKER
Yes,
ASKER
Any suggestion ? Please advise kindly
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
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
and if we can .htmlbody in VBA is same as your suggestion web site
ASKER
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
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
ASKER
Thanks for your reply
Can you give more details of this web page that you want to send?
Sid