Subject line of an email message through code 1

[NC1977]

Good morning,

I have a form, with a command button that once clicked sends my report directly to the users email so that he or she can email this report.

The following is my code:
DoCmd.SendObject acSendReport, "Requete Lawson", , "xxxx.xxxx@lakdsjfl.com", , , Forms![Requete Lawson]![Mandat]

this part "Forms![Requete Lawson]![Mandat]" which is the subject line of the email needs to be dynamic... I want the subject line in the email to be filed with whatever is in the text box: "Forms![Requete Lawson]![Mandat]"

This doesn't work and I was wondering if it's even a feature????

Thank you

 

[Remou]

This should work, however you may need to save the record before running this code. It would be best to include an output format.

 

[PHV]

This doesn't work
What happens ? Any error message ? Unexpected behaviour ? Computer crash ? ... ?

Anyway, [Requete Lawson] should be an opened form with a populated control named Mandat.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NC1977]

Actually the subject line reads Forms![Requete Lawson]![Mandat]....But I think what Remou said is correct, I should save the record first however, half of my form is bound and the other isn't...I'm not sure how to save my record to a new table and then run the email code all in one command button???

 

[Remou]

If the subject line reads
Forms![Requete Lawson]![Mandat]

Then you must have put it in quotes. You do not show quotes in the code you posted, which is fine. If you still have problems, it is best to cut and paste the code here.

 

[NC1977]

Remou it worked! Thank you thank you! wonderful!

 

[NC1977]

Last question, I'm trying to set the output format to Rich text format... How do I put it in my code?? I've tried RTF, Richtextformat, rtf, this doesn't work...any ideas???

Thanks

 

[Remou]

acFormatRTF
Should suit.

You can find these answers by clicking on a keyword such as OutputTo in the code window and pressing F1.