Auto send email with attachment and open the web page as content

Y

yl011229

I can now sending email with attachment by different email address. But I
want to do that when the receiver open my email, a web page displayed as
content with my attachment. Can anyone please tell me how to do this? Thank
you very much!!!

My current coding as follows:

Private Sub Command1_Click()
Dim objoutlook As Object
Dim objmail As Object

Set objoutlook = CreateObject("outlook.application")
Set objmail = objoutlook.CreateItem(0)

With objmail
.Subject = txt_Subject
.To = "(e-mail address removed)"
.Body = txt_Body.Text
.Attachments.Add txt_location & "X723.pdf"
.display
.Send
End With
Set objmail = Nothing
Set objoutlook = Nothing
MsgBox "Sent"
End Sub
 
B

Baz

Not sure what you mean. If you want a browser to launch and show a specific
website when someone opens your email, I don't believe this is possible
(thank goodness). If you want to send an HTML email which obtains content
from the web, this is possible, but is to some extent a waste of time: by
default, Outlook will not fetch web content to display in an email, so
Outlook users will not see your content.

It's a horrible idea anyway: forcing someone to see your web content just
because they opened an email would be a pretty good way to annoy them.

Even an HTML email which doesn't fetch content from the web is not that
great an idea, a lot of people don't like them.
 
Y

yl011229 via AccessMonster.com

I want to send newsletter attached with a pdf files to our client, like some
company's e-statement, when we open the email, we can view the pictures,
links and our statement details without opening the attachment. Some clients
request us to do it, they think its more convenience. Thank you.

Not sure what you mean. If you want a browser to launch and show a specific
website when someone opens your email, I don't believe this is possible
(thank goodness). If you want to send an HTML email which obtains content
from the web, this is possible, but is to some extent a waste of time: by
default, Outlook will not fetch web content to display in an email, so
Outlook users will not see your content.

It's a horrible idea anyway: forcing someone to see your web content just
because they opened an email would be a pretty good way to annoy them.

Even an HTML email which doesn't fetch content from the web is not that
great an idea, a lot of people don't like them.
I can now sending email with attachment by different email address. But I
want to do that when the receiver open my email, a web page displayed as
[quoted text clipped - 22 lines]
MsgBox "Sent"
End Sub
 
B

Baz

yl011229 via AccessMonster.com said:
I want to send newsletter attached with a pdf files to our client, like some
company's e-statement, when we open the email, we can view the pictures,
links and our statement details without opening the attachment. Some clients
request us to do it, they think its more convenience. Thank you.
 
B

Baz

Sending an email with a pdf attachment has nothing to do with opening web
pages.

As far as I know you cannot display a pdf file in the body of an email, you
can only send it
as an attachment. To do what you want you would need to construct your
statement in HTML, not as a PDF.

To do what you want
 
Y

yl011229 via AccessMonster.com

May I know how can I send an email like eNewsletter but not as an attachment?

Thank you.
 
B

Baz

I already told you: send it as an HTML email.

yl011229 via AccessMonster.com said:
May I know how can I send an email like eNewsletter but not as an attachment?

Thank you.
 
Y

yl011229 via AccessMonster.com

May I have some sample coding for sending HTML email? Thank you very much!
I already told you: send it as an HTML email.
May I know how can I send an email like eNewsletter but not as an attachment?
[quoted text clipped - 7 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top