e-mail

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hello,

I have a Data Access Page that doesn't work outside of our network. The page
appears, but does not populate due to certain security reasons.

I'm trying to think of another approach. Could a query, form, or page be
e-mailed to the person requesting the data? e.g. they enter their e-mail
address, and it sends a PDF, or html, or whatever via e-mail?

Any other ideas? My goal is just to send certain info to users outside our
network at their request based on job number.

Thanks for your help,
Joel
 
Hi Joel,

Open the database and create a macro. Under "Action" select "Send Object"
then, go to the bottom and complete the requested information. For output
format, select Microsoft Excel 97-2003. I tried it and seems to pull the
information which I tried from a query. After you created a macro then go to
the form and create a command button and tie the macro to it. One you click
it, it will send the information in an excel spreadsheet via email. FYI - I
am referring doing this from the database. I'm not sure about an access page.

Good Luck!!!
 
Thanks Doug, you're a great help. I tried it and I am getting really close.
It generates an e-mail and attaches the html. The html file is perfect, I
can format just how I need.

What I'm trying though is to have the customer, run the macro (I can
probably do this from my Data Access Page), it would prompt them for their
e-mail address, and it would send the e-mail to them.
 
You're welcome Joel, glad I was able to help.

I'm not sure about the access page as I am not familar with that but I guess
you would set up the button on the page for the customer to click. It should
still generate the report but set the macro up where it allows you to edit
rather that automatically send the email after the click. That way, the
customer clicks the button, the email will pop up for editing and the
customer can enter their email address. Truthfully, I'm shooting from the
hip. This may be possible but it may require some trial and error. I'm sorry
I could not be of more help but what I told you is about all I can help you
with regarding this situation. I wish you the best of luck and hope you can
figure it out. Let me know if you.

Take care,

Doug
 
Back
Top