email subject line

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

  1. fishqqq

    fishqqq 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?

    fishqqq, May 19, 2012
    1. Advertisements

  2. fishqqq

    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. fishqqq

    fishqqq Guest

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

    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.