Help? I want to send access form in the body of email

[Rooter1988]

Hello all, I'm new to the forum. I haven't used access to much in the last year due to my new position. Now that I'm more settled I started diving back into it. I creating a simple user entry database (attached). I want the Save/Send button on form "Canada Projections" to send the current forms 3 labels and text boxes as in an email but not as an attachment. I would like them in the body of an email. Can this be done? I've been scouring the web looking for solutions or at least clues. Can you Help? Thanks!!!

 

[Ranman256]

a single statement

DoCmd.SendObject acSendForm, "forms!frmMain", acFormatPDF, vTO, , , vSubj, vBody

 

[Rooter1988]

Thanks a lot, but i do not see any output. When i input your code and run it i get the Run-time error 2059 and it it says access cannot find the object '1'.

 

[Rooter1988]

I also tried inputting my forms name "Canada Projections" into the frmMain area.

 

[Ranman256]

sorry, i put quotes around the form
dont quote the form.
if you are sending it from the form, try ME

 

[Rooter1988]

when you say ME, where do i put that? Would i replace frmMain with ME?