How can I send a form through e-mail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working on a database that shows a new hire packet that needs to
be filled out by employees. The form has links which are PDF files to be
accessed by the employees to print out. What I am trying to do is to
successfully send an email of this form to an employee. I am finding that
when I put in an event procedure some problems come up. First, I finally got
the form to send by email, but when I send the form the contents of the form
do not show up just a blank screen. Second, after only trying to send the
form a couple of times the code seems to quit working so now I can not even
get it to send by email now. What am I doing wrong?
 
I have been working on a database that shows a new hire packet that needs to
be filled out by employees. The form has links which are PDF files to be
accessed by the employees to print out. What I am trying to do is to
successfully send an email of this form to an employee. I am finding that
when I put in an event procedure some problems come up. First, I finally got
the form to send by email, but when I send the form the contents of the form
do not show up just a blank screen. Second, after only trying to send the
form a couple of times the code seems to quit working so now I can not even
get it to send by email now. What am I doing wrong?
Click to expand...

Assiming that a Form is anything more than a window, a tool for
displaying data from within the database.

The Form isn't "portable" in this way; it doesn't contain any data,
and is of no use except within the database itself.

You can create a Report to send a (static) image of selected data from
your database; to get data back into the database you will need some
VBA code to parse the *text* of an EMail message and enter it into
your tables.

John W. Vinson[MVP]
 
Thank you for the information! I have been asking this for days in different
posts, and you are the first to tell me that you can not send a form by
e-mail. THANK YOU!

Can you still help me I am still having problems. I have created a report
with the same information in it but, I am still receiving an error message
stating that "Employees can't send a message for the reason stated in the
preceding alert." although there isn't a preceding alert. I have created
the macro under the sendobject action. Is this not the correct way to send a
report by e-mail?
 
Thank you for the information! I have been asking this for days in different
posts, and you are the first to tell me that you can not send a form by
e-mail. THANK YOU!

Can you still help me I am still having problems. I have created a report
with the same information in it but, I am still receiving an error message
stating that "Employees can't send a message for the reason stated in the
preceding alert." although there isn't a preceding alert. I have created
the macro under the sendobject action. Is this not the correct way to send a
report by e-mail?
Click to expand...

The phrasing of the message sounds like there is some limitation
imposed by your own company's mail software: an Access (or Microsoft)
error message wouldn't refer to "employees"!

I'm not an expert on SendObject - you might want to start a new
thread, explaining *what you are trying to accomplish in a business
sense* (rather than confusingly talking about "emailing a form"); and
you may want to talk to your company's IT department about mail
restrictions. It's quite possible that (to prevent proliferation of
viruses, for instance) they've blocked programmatic sending of emails
altogether.

John W. Vinson[MVP]
 
Thank you very much for all your input I appreiciate it. I will talk to my
IT dept, and if I can't get anywhere with that I will start a new thread.

Thanks,
 
Back
Top