Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

email subject line

18 views
Skip to first unread message

fis...@hotmail.com

unread,
May 19, 2012, 8:07:02 AM5/19/12
to
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

unread,
May 20, 2012, 11:49:32 PM5/20/12
to
Shamless plug for my software because I have a web page where I use
this asper the following. <smile>

mailto:to...@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:to...@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/

fis...@hotmail.com

unread,
May 21, 2012, 2:21:23 PM5/21/12
to
On May 20, 11:49 pm, Tony Toews <tto...@telusplanet.net> wrote:
> On Sat, 19 May 2012 05:07:02 -0700 (PDT), "fish...@hotmail.com"
>
> <fish...@hotmail.com> wrote:
> >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.

Tony Toews

unread,
May 21, 2012, 6:15:16 PM5/21/12
to
On Mon, 21 May 2012 11:21:23 -0700 (PDT), "fis...@hotmail.com"
<fis...@hotmail.com> wrote:

>> mailto:t...@autofeupdater.com?subject=Auto FE Updater

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/
0 new messages