Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email Subject (2003)

    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

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Email Subject (2003)

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

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Subject (2003)

    Thanks

  4. #4
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Subject (2003)

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

    Regards

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email Subject (2003)

    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.

  6. #6
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Subject (2003)

    Thanks a lot.

    It works.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •