E-Mail Command Button

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
 
T

Terry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
Access command button help needed 0
E-Mail Command Button 6
Using one command button to open one of two reports 3
Data Entry VBA 4
Command Button 1
Command Button Wizard 7
Printing a Range Of Records Using A Button 1

Top