email subject line

  • Thread starter Thread starter fishqqq
  • Start date Start date
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
 
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?
Click to expand...

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/
 
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#]
Click to expand...
can anyone show me how to have this automatically populated with the
correct value?
Click to expand...

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/
Click to expand...

thanks Tony it works perfectly now.
 
Back
Top