Email Subject (2003)

Topic

New Reply

I am use sendObject to email my report as email attachment. How can I link email subject with one field of the form? For example, I have an filed of form calls “User,” I want the email subject to be” Monthly Report with Mark.” Mark is the user that select from the form.

Thanks

Reply | Quote

Replies

Look at post 493538 for an idea on how to get the user’s name

Reply | Quote

Thanks

Reply | Quote

But I don’t have defaul users, I let user to select from the form. Please help!!!!

Regards

Reply | Quote

You could use something like the following, with the appropriate names substituted:

DoCmd.SendObject acSendReport, “rptMyReport”, acFormatRPT, “You@Somewhere.com”, , , “Monthly report for ” & Me.txtUser, “…”

where txtUser is the control in which the user is entered/selected.

Reply | Quote

Thanks a lot.

It works.

Reply | Quote