triggering the 'send' feature in Outlook from Access 2003

I've created an attachment and email from within Access 2003 and it is stored
in Outlook's Outbox until I click on the send/receive menu option in Outlook.

Is there a way that I can automatically trigger the 'send' command in
Outlook from within Access 2003 so that it does the whole job so to speak?

Any help is much appreciated.

Regards

Byzantine

I'd like to know how you "created an attachment and email from within Access
2003"; hopefully, w/o writing code somewhere that I don't know how to do.

I do a monthly newsletter and would like to use the email addresses that are
in an Access Table to create individual emails w/the news attached. Any help?
(Please give me steps.)
V

"Byzantine" wrote:

I've created an attachment and email from within Access 2003 and it is stored
in Outlook's Outbox until I click on the send/receive menu option in Outlook.

Is there a way that I can automatically trigger the 'send' command in
Outlook from within Access 2003 so that it does the whole job so to speak?

Any help is much appreciated.

Regards

Byzantine

Take a look at the Access EMail FAQ Tony Toews has at
http://www.granite.ab.ca/access/email.htm

If you're not up to writing the code, you could check out Total Access
EMailer, from FMS
http://www.fmsinc.com/products/emailer/index.asp

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Vevah" wrote in message
...
I'd like to know how you "created an attachment and email from within
Access
2003"; hopefully, w/o writing code somewhere that I don't know how to do.

I do a monthly newsletter and would like to use the email addresses that
are
in an Access Table to create individual emails w/the news attached. Any
help?
(Please give me steps.)
V

"Byzantine" wrote:

I've created an attachment and email from within Access 2003 and it is
stored
in Outlook's Outbox until I click on the send/receive menu option in
Outlook.

Is there a way that I can automatically trigger the 'send' command in
Outlook from within Access 2003 so that it does the whole job so to
speak?

Any help is much appreciated.

Regards

Byzantine