email subject line


F

fishqqq

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
 
T

Tony Toews

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?
Shamless plug for my software because I have a web page where I use
this asper the following. <smile>

mailto:tony@autofeupdater.com?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:tony@autofeupdater.com?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/
 
Ad

Advertisements

F

fishqqq

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?
Shamless plug for my software because I have a web page where I use
this asper the following.  <smile>

mailto:t...@autofeupdater.com?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:t...@autofeupdater.com?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 seehttp://www.autofeupdater.com/
thanks Tony it works perfectly now.
 
Ad

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. After that, you can post your question and our members will help you out.

Ask a Question

Top