email subject line

Discussion in 'Access Macros' started by fishqqq@hotmail.com, May 19, 2012.

  1. Guest

    I have an emaildatabaseobject function in a macro that is working
    perfectly except i would like the subjec line of the email to show the
    value of :
    Forms![fShptDetails]![FMS Ref#]

    can anyone show me how to have this automatically populated with the
    correct value?

    tks
    Steve
     
    , May 19, 2012
    #1
    1. Advertisements

  2. Tony Toews Guest

    Shamless plug for my software because I have a web page where I use
    this asper the following. <smile>

    mailto:?subject=Auto FE Updater

    Not sure what the macro looks like because I've never used them but if
    you can concatenate strings it might look something like

    "mailto:?subject=" & Forms![fShptDetails]![FMS
    Ref#]

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files
    updated see http://www.autofeupdater.com/
     
    Tony Toews, May 21, 2012
    #2
    1. Advertisements

  3. Guest

    thanks Tony it works perfectly now.
     
    , May 21, 2012
    #3
  4. Tony Toews Guest

    Tony Toews, May 21, 2012
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.