Auto Send Email

[Tim]

Hi,

Does anyone know how to auto send mail through Access? I
am using Lotus Notes to send my email. I think I need to
call Louts Notes application to send the email. But, I
don't know how to do that. Could anyone can help me to
create some code to do it? Or can tell me any program can
schedule a job to auto attached some files and send to a
group of receivers?

Thanks in advance.

Tim.

 

[Sandra Daigle]

Check Tony Toew's website for a good list of resources on creating email
from Access: http://www.granite.ab.ca/access/email.htm

You might also want to check the new program from FMS called Total Access
Emailer: http://www.fmsinc.com/products/Emailer/index.asp It is very simple
to install and set-up and I believe that it also has the ability to schedule
email to be sent at a particular time.

 

[KW]

Tim,
Check help for the docmd object SendObject. You can choose
to send a report, query, table, etc. as we as To, CC, etc.
You can define the subject line as well. There are other
features for this command as well.

I have a function that uses that command and we use Notes
as well and it works fine, the only problem I have run
into with this though is Notes has to be active. I am sure
there is a way to open lotus first, but I have not tried
that yet.

Hope that helps!

KW

 

[Tim]

KW,

Thanks for your respone. I tried the sendObject command.

DoCmd.SendObject acSendTable, "test",
acFormatXLS, "Name", , , "automail", "test"

It did open the Lotus Note, put "automail" in subject
field, attachment the file and then put the cursor in the
TO: field. But, it didn't auto send mail.

Did I do anything wrong or I need some setting? Also,
could you tell me how to attach some files instead just
attach report or table?

Please help.

Thanks.

Tim

 

[Tim]

Sandra,

Thanks for your info. I checked Tony Toew's website, but
I couldn't figure out to send the mail through Notes.

Could you help me out?

Thanks.

Tim.

-----Original Message-----
Check Tony Toew's website for a good list of resources on creating email
from Access: http://www.granite.ab.ca/access/email.htm

You might also want to check the new program from FMS called Total Access
Emailer: http://www.fmsinc.com/products/Emailer/index.asp It is very simple
to install and set-up and I believe that it also has the ability to schedule
email to be sent at a particular time.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Hi,

Does anyone know how to auto send mail through Access? I
am using Lotus Notes to send my email. I think I need to
call Louts Notes application to send the email. But, I
don't know how to do that. Could anyone can help me to
create some code to do it? Or can tell me any program can
schedule a job to auto attached some files and send to a
group of receivers?

Thanks in advance.

Tim.

.