Change output file name during send object routine

[aftershokk]

I have a query that runs based on a parameter a user selects on a form.

I want to dynamically create the sendobject file name based on the parameter the user selects.

Example:

My form has a parameter named medicine. When the user checks the checkbox next to medicine it runs a query for records labeled as medicine but sends the e-mail output as the query name. I want something like medicine.txt etcc...

thanks

 

[ezfriend]

Sounds like you want to export your output to a file and then sent it.

Look at the Open Statement.