Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send a simple note via e-mail? 1

Status
Not open for further replies.

JavaTurkey

Technical User
Dec 24, 2001
42
US
Ok, I'm new to VBA coding, but I need help writing a simple code to send a certain field or two as the BODY of an e-mail through outlook. I can get it as an attachment, but not as the body. Any suggestions? Thanks-
 
Here is the DoCmd.SendObject format...just put the field names into the message text section....like:

[Text1} & [Text2] & [Text3] etc...

Good Luck


DoCmd.SendObject ,,acFormatRTF, to name , cc name , BCC Name , Subject , Message Text , Edit Mesage True/False
"As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein [spin]

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top