docmd.sendObject

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I would like to send out email from my app.

I use docmd.sendObject methodwhich works.
It uses current email program to send email.
MS Outlook always to prompt user to confirm the email Outlook is sending out.

I would like to Outlok sends out email silence. Are there any work around
that let outlook sends out email silence?

Your information is great appreciated,
 
Souris said:
MS Outlook always to prompt user to confirm the email Outlook is sending out.

I would like to Outlok sends out email silence. Are there any work around
that let outlook sends out email silence?
Click to expand...

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
The example in the FAQ which outlook can send the mail silence without prompt
user to confirm?

Thanks again,
 
Souris said:
The example in the FAQ which outlook can send the mail silence without prompt
user to confirm?
Click to expand...

To be more precise see the bordered section on that page titled
""A program is trying to automatically send e-mail on your behalf."
"A program is trying to access e-mail address you have stored in
Outlook.""

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Thanks,

I got it,




Tony Toews said:
To be more precise see the bordered section on that page titled
""A program is trying to automatically send e-mail on your behalf."
"A program is trying to access e-mail address you have stored in
Outlook.""

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Click to expand...
 
I got message

The "SendUsing" configuration value is invalid

when I use SMTP to send out the email.

Any thing I can look for this?

Thanks again
 
Souris said:
I got message

The "SendUsing" configuration value is invalid

when I use SMTP to send out the email.
Click to expand...

No idea as I don't use Outlook. However that sounds like the mail
server name or your email userid and password (which is likely the
same as your ISP userid and password) hasn't been setup properly
within Outlook.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Souris said:
I got message

The "SendUsing" configuration value is invalid

when I use SMTP to send out the email.

Any thing I can look for this?

Thanks again
Click to expand...

Const Prefix = "http://schemas.microsoft.com/cdo/configuration/"
Const cdoSendUsingPickup = 1
Const cdoSendUsingPort = 2

With CDO.Message.Configuration.Fields
.Item(Prefix & "sendusing") = cdoSendUsingPort
End With

If you need further help with this, please post the code you are using.
 
oEMail.From "(e-mail address removed)"
oEMail.To "(e-mail address removed)"
oEMail.BodyFormat = CdoBodyFormatText
oEMail.Body = "Insert some useful text here"
oEMail.Importance = CdoHigh
oEMail.AttachFile "C:\filename.txt"
oEMail.Send

Here is my code,

I have CDO in my library

Your information is great appreciated,
 
Souris said:
oEMail.From "(e-mail address removed)"
oEMail.To "(e-mail address removed)"
oEMail.BodyFormat = CdoBodyFormatText
oEMail.Body = "Insert some useful text here"
oEMail.Importance = CdoHigh
oEMail.AttachFile "C:\filename.txt"
oEMail.Send

Here is my code,

I have CDO in my library

Your information is great appreciated,
Click to expand...

You have supplied incomplete code, namely how oEmail is being declared.
Hopefully it is:

Set oEmail = New CDO.Message

You need to post that bit before we can help.

Also, your references ought to include 'Microsoft CDO for Exchange 2000
Library' or similar. (In the VB editor, Tools->References)
 
Back
Top