Email Subject (2003)

[garyfei]

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

[patt]

Look at <post#=493538>post 493538</post#> for an idea on how to get the user's name

[garyfei]

Thanks

[garyfei]

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

Regards

[HansV]

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.

[garyfei]

Thanks a lot.

It works.