A
Ally
We are sending Pickup requests to the same group of
customers weekly (All customers do not require these
requests every week, only when the "Returns" table has
records for that particular customer). Currently we have
a temporary table that is appended with records for one
customer at a time, then we are using the SendObject
command in a macro to send the Pickup request via e-mail.
The temp table is deleted and the process is repeated for
each customer. This is all being done within one macro.
Is there a way to validate the query before it is sent
(using the SendObject command). So that blank records are
not sent to customers who do not have records in
the "Returns" table. I.e. only send the request to that
customer if the query is not blank?
Any suggestions would be greatly appreciated.
Thank you,
Ally
customers weekly (All customers do not require these
requests every week, only when the "Returns" table has
records for that particular customer). Currently we have
a temporary table that is appended with records for one
customer at a time, then we are using the SendObject
command in a macro to send the Pickup request via e-mail.
The temp table is deleted and the process is repeated for
each customer. This is all being done within one macro.
Is there a way to validate the query before it is sent
(using the SendObject command). So that blank records are
not sent to customers who do not have records in
the "Returns" table. I.e. only send the request to that
customer if the query is not blank?
Any suggestions would be greatly appreciated.
Thank you,
Ally