Hello,
I have created a query that produces a report when I click on a command button. It pulls the data and creates a report and is presented in print preview. I added a run command and am telling it to send. At this point I get the "select format" options. I select rtf or html and it then opens my outlook email with the attachment and waits for the email address input to send it off.
Is there a way to automate this? I would like to make it as simple as possible for the end users.
Best case senairo;
I am in the database
The record is up (In View)
I click on the button
The report is automaticlly generated and outlook is loaded with the page to be sent with the recipeients email address already in the To box.
Could I create a macro or something that does this based on an email field in the records current view? (the one I am sending?) or from a table in the database?
Thanks,
Fen How
I have created a query that produces a report when I click on a command button. It pulls the data and creates a report and is presented in print preview. I added a run command and am telling it to send. At this point I get the "select format" options. I select rtf or html and it then opens my outlook email with the attachment and waits for the email address input to send it off.
Is there a way to automate this? I would like to make it as simple as possible for the end users.
Best case senairo;
I am in the database
The record is up (In View)
I click on the button
The report is automaticlly generated and outlook is loaded with the page to be sent with the recipeients email address already in the To box.
Could I create a macro or something that does this based on an email field in the records current view? (the one I am sending?) or from a table in the database?
Thanks,
Fen How
