sending emails

[janliv1102]

I have a databsae that includes the invoices of different companies. I have
created a sendobject macro for each indvidual company that send emails to
their company if they have not paid for their invoice. I have also created a
macro that sends all the emails at once with just the click of that one
macro. My problem is that I can not figure out a way to only send the emails
all at once to just the companies that have unpaid invoices, the companies
that have paid do not get any email messages. I want to be able to send these
emails out weekly. Any suggestions is greatly appreciated. Thanks

 

[Klatuu]

You might want to ask your question in the Macros group.
I would know how to do it using VBA, but I don't use Macros execpt to modify
those I inherit. I do know you can do conditional statements in Macros, but
I don't know exactly how to use them. My point is, that someone watching the
Macros group would surely be able to give you good help.

 

[janliv1102]

How would you do it using VBA?

You might want to ask your question in the Macros group.
I would know how to do it using VBA, but I don't use Macros execpt to modify
those I inherit. I do know you can do conditional statements in Macros, but
I don't know exactly how to use them. My point is, that someone watching the
Macros group would surely be able to give you good help.

 

[Klatuu]

How do you know if an invoice is past due?

Basically, I would create a recordset of customer information needed to send
the emails that have over due invoices, then loop through the recordset and
send the email to everyone in the recordset.

If you can tell me a bit about your tables and how to determine whether an
invoice is overdue, I will be happy to help. Also, a question for you. If a
customer has multiple overdue invoices, how do you handle that?

 

[Arvin Meyer [MVP]]

You need a query to isolate which invoices haven't been paid. I suspect that
you know which invoices have been paid because you have a received date on
them, so use:

Is Null

as the criteria in the date field. Then use your macro with the query as
your recordsource.

 

[janliv1102]

well I have already set up a query that will show me what is paid and what is
not paid. I did it the same way as you had mention using the null. Another
question is where is the recordset? Could you please give me more of a
detailed explanation. Thank you so very much. Your help is greatly
apprecitated.

 

[Arvin Meyer [MVP]]

The recordsource IS the query. You build a string from the values in the
query, see:

http://www.datastrat.com/Code/MultipleEmail.txt

and you'll see a recordset built from qryContacts and used to send multiple
emails.

If you want to reinvoice each customer, you need something a bit more
sophisticated, because you will be sending multiple emails, each with a
different attachment. For that I use 3rd part code:

http://www.groupacg.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Marie-France GERENTON]

High,

I do hope that someone can hel me with my problem. Since I agreed to have
some 'mises a jour' done, all the e_mails I send go to a folder in outlook
express and I have to resend them several times. The worse in all this, is
that nobody ever receives my mails!!!!!!!!!!!!

Another very strange thing is that I delete some unwanted mails, they go
into the deleted items folder, and when I really want to delete them all, I
get this message "une erreur inconnue s'est produite' which means that an
unknown error occurred!!

Can anybody help me please? I need to send some mails urgently now.

Thanks you chaps

Marie-France

 

[janliv1102]

Ok. So far you are doing a really great job of helping me. Although I have
one more question. I'm sure this is very silly question and I think that I
know the answer but I am not positive but where do I put that script that you
gave me. Do I just create a module and put in there? PLease Help. Thanks you
so much.

 

[janliv1102]

ummmmm....when you have a question to ask you need to create your own post.
It is proper to post in someone elses's post (mine) like you did. Thanks

 

[Arvin Meyer [MVP]]

Yes, just paste it into a standard module. Make sure that you don't name the
module the same as the function, and also make sure that you set a reference
to Microsoft Outlook (your version) in the code window:

Tools >>> References
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com