how do i e-mail from access

[Guest]

I have made an accounting package using access. Can u pls help me to e-mail
the accounts directly to the customers? I get the accounts by using a query
from a "transaction" table sorted by customer. Now I need to e-mail this
account by using the e-mail in each of the "customers'" table.

Thank you in advance

 

[Douglas J Steele]

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

 

[Alex White MCDBA MCSE]

Depends on what you are trying to do with the email, if the email is a non
attachment, plain text email then using the winsock.dll that is embedded
within IE is the most reliable method, using systems like outlook will give
you more feature but then you run in all sorts of different problems, I
would seriously go with some of Doug's as some of them use the winsock idea,
try to keep away from the winsock.ocx and stick with the winsock.dll as you
could spend a load of time just messing with winsock otherwise.

If you want fancy HTML style emails, then this is possible via the winsock
method but gets more complicated.

 

[Guest]

Have you tried the report wizzard ? I put a control on my forms that just
e-mails the report. the wizzard allows you to select transmission protocols,
or, have i missed something here?

 

[adsl]

Have you tried the report wizzard ? I put a control on my forms that just
e-mails the report. the wizzard allows you to select transmission
protocols,
or, have i missed something here?