E-Mail Command Button

  • Thread starter Thread starter Hulk
  • Start date Start date
H

Hulk

Hi all,
I was trying to put a command button on a form to send a report. I use
the wizard to build the button but it sends all the reports to Outlook in a
html format. Is there a way to select only the form displaed on the screen
when the button is pressed?
Please make it as simple as possible as I am not very good at this
programming yet.

Thanks in Advance
 
Try:

docmd.SendObject
acSendForm,<Formname>,,<To>,<cc>,<bcc>,<Subject>,<MessageText>,<EditMessage>

That is all one line.
For more info try the Help, it covers it fairly well.
The EditMessage parameter can be true or false; True means you want to edit
the message before sending it so it will be popped up in Outlook ready for
your editing.
HTH
Terry
 
Back
Top