email Invoice

[rkulik]

ok heres what's going on. I run a query and it generates a table with 10
users with 10 email addresses, balances, etc

I want to email each user their invoice based on the query that just ran. A new message for each user.

I can send email via access using the SendObject method and that works fine,
one user at a time. But I would like to be able to have Access go through
the list and email each user the earlier query created.

Any ideas how to get it to work?

Erin

 

[Cheeky]

I wanted to do this a while back and someone sent me a piece of code they had written called "custom email reports". I have sent it via email but I cannot remember who it was that sent me the code in the first place. Whoever it was is a lifesaver and deserves the credit for it. Its pretty simple to work out how it all works and customise it to your own needs.

HTH

Jim

 

[Atomic Shrimp]

<blushes>

 

[Glen]

Any chance of getting a copy of this could I could certainly make good use of it??

 

[skiphooper]

Mike,

Thanks Again, Great Demo

Skip

 

[N.S.Rao]

Email Reports

I have to send individual reports on a daily basis to my branches. the records have to be selected using a query with parameters Date and Branch name. I now do it one by one and use the send object method to send the reports by email.This code will be highly useful to me. Can I have this code please ?
thanks

 

[steve728]

I'd like to have a copy of the custome email code also Please.

Steve