SendObject

[Ron]

Hi all,
I created a button to email report.
I would like to add massege in the mail body. I know I can put it in the
code, but it's quite long and I want the user to change it as he see fit.

Is there a way o do it, or the code is the only way?

Thanks,
Ron

 

[Allen Browne]

Did you realize that if you specify True for the EditMessage argument of
SendObject, the user can type directly into the body of their email?

Alternatively, you could create a form with text boxes where the user can
enter the recipient, title, and message. This example assumes text boxes
named txtEmail, txtSubject, and txtMessage:

DoCmd.SendObject acSendReport, "Report1", , Me.txtEmail, , , _
Me.txtSubject, Me.[txtMessage], True

 

[Ron]

Allen,
When you write the text in the code you create defualt text to the email.
How can you change that?

Thanks,
Ron

Did you realize that if you specify True for the EditMessage argument of
SendObject, the user can type directly into the body of their email?

Alternatively, you could create a form with text boxes where the user can
enter the recipient, title, and message. This example assumes text boxes
named txtEmail, txtSubject, and txtMessage:

DoCmd.SendObject acSendReport, "Report1", , Me.txtEmail, , , _
Me.txtSubject, Me.[txtMessage], True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi all,
I created a button to email report.
I would like to add massege in the mail body. I know I can put it in the
code, but it's quite long and I want the user to change it as he see fit.

Is there a way o do it, or the code is the only way?

 

[Allen Browne]

Ron, try creating a form, not bound to any table.
Add 3 text boxes with the names suggested.
Add a command button, and put the line of code into the Event Procedure for
its Click event.

See how it works by reading whatever text you (the user) type into the text
box, and dropping that text into the body of the email.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,
When you write the text in the code you create defualt text to the email.
How can you change that?

Thanks,
Ron

Did you realize that if you specify True for the EditMessage argument of
SendObject, the user can type directly into the body of their email?

Alternatively, you could create a form with text boxes where the user can
enter the recipient, title, and message. This example assumes text boxes
named txtEmail, txtSubject, and txtMessage:

DoCmd.SendObject acSendReport, "Report1", , Me.txtEmail, , , _
Me.txtSubject, Me.[txtMessage], True

Hi all,
I created a button to email report.
I would like to add massege in the mail body. I know I can put it in the
code, but it's quite long and I want the user to change it as he see
fit.

Is there a way o do it, or the code is the only way?

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George