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
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