I added a user field, Can I use it in the email templates?

I added a company name field to my sign up for which will be for dealers. They will be adding subusers to their account. I was trying to get the email to say

"Company name" has created an account for you on...

Is this a possibility? I tired to look the other %name% fields in the email templates but I could not locate the userfield that I created in the database to attempt to copy to see if this worked.

thanks

Changed it to SQL and left it set to string. Tried adding %user.company% and it didn't come through and yes the field name it company. I can see it the database table am_user in spot #33 company. Looking at the other fields though I think it would have to be something like %reseller.company% which I tried. Based on main user first name which worked I also tried %reseller_company% with no luck.

Since %user.company% is not a field used for the subuser accounts only the primary accounts, what would the correct place holder be for amember to look at the main user that created the subuser account and then display the added "company" field.

**Switching to SQL allowed me to sort the browse users tab by company name which was something that I was bummed that I couldn't do before so YAY!

You should be able to type %user.company% in any templates, like email templates, where you would like the company name to appear. With it set as an SQL field, and a little help from aMember support, you could get it to pre-populate data based on different conditions.

Ryan