Form details to Email

stu_c

Registered User.
Local time
Today, 18:21
Joined
Sep 20, 2007
Messages
493
Hi all
hopefully someone can help

I have a form with combo boxes, and fields that a user fills out once complete it needs to be Emailed off, the details need to go into the body of a Email template how do I do this?

The Field Names are
ReportingPerson
SiteName
Details
DateAndTime (Automatically Put in)


if someone can help me would be ideal is I am completely lost on how to do it, if someone is able to do me a very simple Email Template and form that works with it would be very grateful :)
 
you can have a text box txtBody, that get the assembled data:
Code:
sub btnSEnd_Click()
txtBody = "my message from "
txtBody = txtBody & me.ReportingPerson
txtBody = txtBody & me.Details
etc...

'send email here....

end sub
 
you can have a text box txtBody, that get the assembled data:
Code:
sub btnSEnd_Click()
txtBody = "my message from "
txtBody = txtBody & me.ReportingPerson
txtBody = txtBody & me.Details
etc...

'send email here....

end sub

any thanks, the Email has a table that the info needs to go into the correct place will this allow me to do this, just tried the above nothing seems to happen?
 
Last edited:
Do you already have code to Email with? If not, search the forum for "Email". That should give you several options (POP3 OR Outlook).

As for getting your values into the EMail, you simply format a string with what ever text literals you wish and your fields. Please let us know if you do/don't know how to do this.
 
Do you already have code to Email with? If not, search the forum for "Email". That should give you several options (POP3 OR Outlook).

As for getting your values into the EMail, you simply format a string with what ever text literals you wish and your fields. Please let us know if you do/don't know how to do this.


Hello mate
Thanks for the reply no I don't have the code all I have done is made a outlook template, it's a new thing for me to do this so not sure where to start
 
@stu_c,

Do a search over in "Modules & VBA" first to learn about HOW to send Email. If it is with Outlook you may not need the template as you can customize the body any way you wish from within the sub you create to handle Emailing.
 

Users who are viewing this thread

Back
Top Bottom