email subject line

[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

 

[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:[email protected]?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:[email protected]?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/

 

[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:[email protected]?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:[email protected]?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.

 

[Tony Toews]

BTW you can do a lot more than just the subject. See
https://en.wikipedia.org/wiki/Mailto

thanks Tony it works perfectly now.

Awesome!

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/