Is there a way to save a routing slip that will prompt the user of the excel
template to select the appropriate e-mail recipients on each use?
I have an excel template (travel/training) request created that needs to be
mailed to various routing recipients on each use which is dependent on the
requestor, the dollar amount and/or type of request. I would like the
requestor to be prompted when closing the file to complete the routing slip.
I would like to have the subject and message text to be consistent with each
request. I know that I can use if..then statements, but that is way to
complex for this simple form.