Access automation email

  • Thread starter Thread starter Pohihihi
  • Start date Start date
P

Pohihihi

Hey NG,

At my work place I have to make small changes to this DB. Basically what I
need to do it to filter some information and email it to the user after
every few days or as scheduled. My problems are these as I have never worked
on any kind of automation on Access2000 -

1- How to automate email feature for bulk emailing or regular reminder
emails
2- How to trigger that feature automatically after a given time when it is
implemented
3- Do I need to write a scheduler for that
4- Can we make that feature more user friendly by letting know where did the
email go and save its contents for record


Any kind of pointers or code will help.

Thanks,
Pohihihi
 
Hi Pohihihi,

1: http://www.granite.ab.ca/access/email.htm has lots of information and
links re emailing from Access.

2: Access forms have built-in timers: you can put code in the OnTimer
event procedure to do whatever you want.

4: Yes: have the same code that creates and sends the email store the
details in a table.

Hey NG,

At my work place I have to make small changes to this DB. Basically what I
need to do it to filter some information and email it to the user after
every few days or as scheduled. My problems are these as I have never worked
on any kind of automation on Access2000 -

1- How to automate email feature for bulk emailing or regular reminder
emails
2- How to trigger that feature automatically after a given time when it is
implemented
3- Do I need to write a scheduler for that
4- Can we make that feature more user friendly by letting know where did the
email go and save its contents for record


Any kind of pointers or code will help.

Thanks,
Pohihihi
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Pohihihi said:
Hey NG,

At my work place I have to make small changes to this DB. Basically what I
need to do it to filter some information and email it to the user after
every few days or as scheduled. My problems are these as I have never worked
on any kind of automation on Access2000 -

1- How to automate email feature for bulk emailing or regular reminder
emails
2- How to trigger that feature automatically after a given time when it is
implemented
3- Do I need to write a scheduler for that
4- Can we make that feature more user friendly by letting know where did the
email go and save its contents for record
Click to expand...


Consider checking out the new product from FMS, Total Access Emailer.
I've heard good things about it in other groups, but haven't tried it
myself. Read about it at

http://www.fmsinc.com/products/Emailer/index.asp

hth,

LeAnne
 
thanks all


Hey NG,

At my work place I have to make small changes to this DB. Basically what I
need to do it to filter some information and email it to the user after
every few days or as scheduled. My problems are these as I have never worked
on any kind of automation on Access2000 -

1- How to automate email feature for bulk emailing or regular reminder
emails
2- How to trigger that feature automatically after a given time when it is
implemented
3- Do I need to write a scheduler for that
4- Can we make that feature more user friendly by letting know where did the
email go and save its contents for record


Any kind of pointers or code will help.

Thanks,
Pohihihi
 
Back
Top