Powermail -- Display selected receiver in email

View: New views
4 Messages — Rating Filter:   Alert me  

Powermail -- Display selected receiver in email

by Tony Lush :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

We are using Powermails capability that the user can select a receiver
from a select box, but when we want to display that in the recipient
email only the form field's UID number is available to display.

In the Recipients tab we assign to the Alternative SQL-Query
"select email FROM fe_users where uid = ###UID12###"

Is ther any way to display the feuser's user name or email address in
the emails?

Thanks -- Tony
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Powermail -- Display selected receiver in email

by Chris Müller-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Tony,

you can use a hidden field, where you can set as additional settings the
appropiate fe_user field. So it would be available via an uid.

Chris.


Tony Lush schrieb:

> We are using Powermails capability that the user can select a receiver
> from a select box, but when we want to display that in the recipient
> email only the form field's UID number is available to display.
>
> In the Recipients tab we assign to the Alternative SQL-Query
> "select email FROM fe_users where uid = ###UID12###"
>
> Is ther any way to display the feuser's user name or email address in
> the emails?
>
> Thanks -- Tony
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Powermail -- Display selected receiver in email

by Tony Lush :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Chris,

Thank you. I tried that, but I was only allowed to look for the Sender's
  fe_user details. What I want to do is
"select username FROM fe_users where uid = ###UID12###"
when ###UID12### is the selected Recipient of the form data.

Thank you -- Tony


Chris Müller wrote:
> Hi Tony,
>
> you can use a hidden field, where you can set as additional settings the
> appropiate fe_user field. So it would be available via an uid.
>
> Chris.
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Powermail -- Display selected receiver in email

by Chris Müller-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Tony,

can't you use the "Alternative SQL-Query" in the "Recipients" divider? I
think that is made for that.

Chris.

Tony Lush schrieb:
> Chris,
>
> Thank you. I tried that, but I was only allowed to look for the Sender's
>  fe_user details. What I want to do is
> "select username FROM fe_users where uid = ###UID12###"
> when ###UID12### is the selected Recipient of the form data.
>
> Thank you -- Tony
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english