email from a form by clicking on a command button...

  • Thread starter Thread starter Jim Wood
  • Start date Start date
J

Jim Wood

Can someone direct me to information on VBA code to send an email from a
form which will include information from the form? I was using HTMLMailer,
but I can not figure out how to set it up with a user id and password and
they no longer appear to be in business.

Thanks,

Jim
 
Jim Wood said:
Can someone direct me to information on VBA code to send an email from a
form which will include information from the form? I was using HTMLMailer,
but I can not figure out how to set it up with a user id and password and
they no longer appear to be in business.
Click to expand...

Depends on how you want to send the email. Outlook Express, Outlook
or others? Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

In VBA code you can create the body of the email by using syntax such
as
strBody = Me.ControlName & vbcrlf & me.control2 & " some text " & _
me,control3
and so forth.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top