code for expression

  • Thread starter Thread starter janliv1102
  • Start date Start date
J

janliv1102

I have a RumMacro that send multiple emails to all my customers about their
invoices. I need help coming up with an expression that I can build so that
it will only email the customers who are not credit released. If a customer
is credit released we enter a date into the credit released field if not we
leave it blank. At the moment all my customers( released and not released)
are getting emails I only want the ones who are not released to get the
emails. isn't there a true expression or a way that I can say if the credit
release field is empty then it is true and send them emails if it does have a
date then its false and do not email. I know there is a way I just can not
figure it out. All the help is greatly apprecitated and thanks very much.
 
Janliv,

You might need to give us the specific details of the macro you are
using, and the process by which it works, if you want a specific answer.
But somewhere along the line, you will need to be using a criteria
like this:
[credit released] Is Null
 
Well the idea of the Macro is for me to put all the customers emails into it.
What I want the macro to do is filter through the emails and all the ones
that do not have a credit released date I want those customers to recieve an
email saying that they have not paid. I hope this is more helpful.

Steve Schapel said:
Janliv,

You might need to give us the specific details of the macro you are
using, and the process by which it works, if you want a specific answer.
But somewhere along the line, you will need to be using a criteria
like this:
[credit released] Is Null

--
Steve Schapel, Microsoft Access MVP
I have a RumMacro that send multiple emails to all my customers about their
invoices. I need help coming up with an expression that I can build so that
it will only email the customers who are not credit released. If a customer
is credit released we enter a date into the credit released field if not we
leave it blank. At the moment all my customers( released and not released)
are getting emails I only want the ones who are not released to get the
emails. isn't there a true expression or a way that I can say if the credit
release field is empty then it is true and send them emails if it does have a
date then its false and do not email. I know there is a way I just can not
figure it out. All the help is greatly apprecitated and thanks very much.
 
Janliv,

Did you try using the Condition I suggested? How did it go?

When I said "specific details of the macro", sorry, I meant what are the
Actions and Arguments of the macro?
 
Yes, it worked.. Thanks so much for your help. If I have any more problems I
hope its you that helps me out. Your explanations and answers were very
illustrated and simple to understand. Thanks
 
Back
Top