code for expression

August 01st, 2008 - 11:45 am ET by janliv1102 | Report spam
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.
email Follow the discussionReplies 4 repliesReplies Make a reply

Replies

#1 janliv1102
August 05th, 2008 - 08:11 am ET | Report spam
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

"Steve Schapel" wrote:

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?

Steve Schapel, Microsoft Access MVP

janliv1102 wrote:
> 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.



Similar topics