Access automation email

[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

 

[John Nurick]

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

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[LeAnne]

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

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

 

[Pohihihi]

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