C
CanFlightSim
I am new on the forum, so I beg your patience.
Yesterday I wrote code for a user to double click on an e-mail address
opening it in an e-mail message and also to update the contact
incidents table with a new record with date and "email sent to broker".
Nothing spectacular.
Hero only for a day ... now ....
I have been given a new challenge on this database.
table - Broker Information (contains name, address, etc and e-mail
address)
Subtable - contact incidents
Criteria fields: FTP (y/n) EDT (y/n) RTV(Y/N)
Here is what we want to do.
Open a form and Select the criteria (parameters) for the query. (will
be y/n)
Type in a string (eg. "E-mail FTP Questionaire") that will go into each
person parsed by the query criteria.
Select if it is to be an e-mail merge or a lable merge out of the
broker table.
Click Run ...
Routine runs the e-mail merge, adds "n" records to the contact
incidents with date and the form's string per each record.
Am I out of my tree? Or can this be done. Have I given you enough
information.
Thanks for bailing me on this. Some day I hope to be contributing to
this forum.
Bill
Yesterday I wrote code for a user to double click on an e-mail address
opening it in an e-mail message and also to update the contact
incidents table with a new record with date and "email sent to broker".
Nothing spectacular.
Hero only for a day ... now ....
I have been given a new challenge on this database.
table - Broker Information (contains name, address, etc and e-mail
address)
Subtable - contact incidents
Criteria fields: FTP (y/n) EDT (y/n) RTV(Y/N)
Here is what we want to do.
Open a form and Select the criteria (parameters) for the query. (will
be y/n)
Type in a string (eg. "E-mail FTP Questionaire") that will go into each
person parsed by the query criteria.
Select if it is to be an e-mail merge or a lable merge out of the
broker table.
Click Run ...
Routine runs the e-mail merge, adds "n" records to the contact
incidents with date and the form's string per each record.
Am I out of my tree? Or can this be done. Have I given you enough
information.
Thanks for bailing me on this. Some day I hope to be contributing to
this forum.
Bill