Auto_emails all reps in quary with attachmet using Access2003

[Indu]

Dear All,
I will be very grateful if some help me.
I have sales quarries data table. Everyday end of the day I am sending
emails to all of our reps attaching word doc with this quarries. I include
with mail merge doc.
How do I send Auto emails one time with attaching mail merge doc.
Need to do with command button. When I press button do mail merge and send
email to reps.
Rep name and rep email address include in my database (new to VB)
Thanks in advance.
Indu UK

 

[David Lloyd]

The following KB article may be a good reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;318881

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Dear All,
I will be very grateful if some help me.
I have sales quarries data table. Everyday end of the day I am sending
emails to all of our reps attaching word doc with this quarries. I include
with mail merge doc.
How do I send Auto emails one time with attaching mail merge doc.
Need to do with command button. When I press button do mail merge and send
email to reps.
Rep name and rep email address include in my database (new to VB)
Thanks in advance.
Indu UK

 

[Indu]

Thakyou so much.
Indu