Sending EMaiil from Access....

[Eugene]

Greetings,

I have code built using DoCmd.Sendobject and it works fine. My question is :

Is there anyway for the email to be sent immediatly with out an outlook box
poping up?

Thanks in advance.....

Eugene

 

[Ivan Grozney]

Eugene,

Which version of Access are you using? Pre 2007 you can use SMTP.

Vanya

 

[tkelley via AccessMonster.com]

I agree with Ivan the Terrible. I've used SMTP with good success. There are
other work-arounds to dealing with that popup, but none that have sounded
clean to me.

So if you have the support of your company's network admin, look into this:

http://www.tek-tips.com/viewthread.cfm?qid=1369407

If not, here is another place to get some ideas:

http://www.outlookcode.com/article.aspx?id=52

 

[Eugene]

I am running A2003 on xp ....

Eugene,

Which version of Access are you using? Pre 2007 you can use SMTP.

Vanya

 

[Tony Toews [MVP]]

Which version of Access are you using? Pre 2007 you can use SMTP.

What makes A2007 so special you can't use SMTP with it? Also what do
you mean by SMTP in this sense? Programming against the Winsock API?

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/

 

[Ivan Grozney]

I use CDO to build my message and ship it out via my SMTP server. The
CDO.DLL is not in Access 2007. So when the users run the Access 2003
database on 2007 it fails because of the missing DLL.

Somewhere along the line I read in several places that Access 07 doesn't
support CDO anymore.

However, I did find the CDOSYS.DLL in Access 2007 but so far have not tired
it yet so maybe I shouldn't beleive everything I have read.

Vanya

 

[Tony Toews [MVP]]

I use CDO to build my message and ship it out via my SMTP server. The
CDO.DLL is not in Access 2007. So when the users run the Access 2003
database on 2007 it fails because of the missing DLL.

Somewhere along the line I read in several places that Access 07 doesn't
support CDO anymore.

I vaguely recall something about CDO no longer coming with Windows
Vista but not with respect to Access. However you could still
download it if desired.

However A2007 should still work with CDO in the same way that previous
versions of Access did.

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/