email subject line

Discussion in 'Access Macros' started by, 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?

    , May 19, 2012
    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

    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages -
    Tony's Microsoft Access Blog -
    For a convenient utility to keep your users FEs and other files
    updated see
    Tony Toews, May 21, 2012
    1. Advertisements

  3. Guest

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

    Tony Toews, May 21, 2012
    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.