L
Les
Hi all, i am opening a form "frmPUR_OutstandingPurchaseOrdersTm-3" that
has a Sub form on which is based on a query "qryPUR_Tm3NoPoDetails".
I have another query "qryPUR_Tm3NoPoDetailsReport", this query i use to
create an excel spreadsheet that must must be sent as an attachment
with the mail, i this further query as i only want to send the mail to
people with a "Delay" of 14 days or more. in this query there are 6
fields of which one has the "byrName" or surname of the person that an
e-mail should be sent to.
The e-mail is in a table "tblBuyers" under the field "EmailName" the is
also a field "byrName".
What i want to do, is when the form is opened and a manager clicks on a
button, the e-mail must be sent automatically to the people that have
purchase orders outstanding for 14 days or longer ?
Should i perhaps include the "EmailName" in the query ?
I am not a programmer but a dabbler, so any help would be appreciated.
has a Sub form on which is based on a query "qryPUR_Tm3NoPoDetails".
I have another query "qryPUR_Tm3NoPoDetailsReport", this query i use to
create an excel spreadsheet that must must be sent as an attachment
with the mail, i this further query as i only want to send the mail to
people with a "Delay" of 14 days or more. in this query there are 6
fields of which one has the "byrName" or surname of the person that an
e-mail should be sent to.
The e-mail is in a table "tblBuyers" under the field "EmailName" the is
also a field "byrName".
What i want to do, is when the form is opened and a manager clicks on a
button, the e-mail must be sent automatically to the people that have
purchase orders outstanding for 14 days or longer ?
Should i perhaps include the "EmailName" in the query ?
I am not a programmer but a dabbler, so any help would be appreciated.