Emailing the contents of a form

[matpj]

I have a form full of unbound text boxes, and want to email the contents of these fields.

Is this possible?
do I have to now create a table and redo the form?
I want to send an email but without an attachment ideally - just have the text-box name and contents embedded in the text of the email.

 

[JoeMiller]

If you provide me your email address I can send you a sample database that takes advantage of DougP's FAQ (in the General Access forum) on this subject. It uses all unbound textboxes to send text.

Joe Miller
joe.miller@flotech.net

 

[matpj]

Thanks,
my email address is matpj@another.com

 

[matpj]

Is it possible to email automatically - i.e. specify an email address, and press a button that will send the mail, rather than bring up the mail-program to do manually?

 

[JoeMiller]

You can accomplish that using the SendObject method. It wouldn't be too hard to setup. DougP also has a FAQ on this subject in the General Access Forum, I suggest you check it out!
Joe Miller
joe.miller@flotech.net

 

[matpj]

I have looked at the email database, but cant understand how the attachements works - if it even does?!!

any ideas?

 

[JoeMiller]

Type in a path and file name for the email db. It does work.
Joe Miller
joe.miller@flotech.net