Mass email users & include user profile field

[Elenna]

I figured it out!

** Warning - this requires that you edit a core file. If you upgrade, you will need to re-edit! **

Open up /admincp/email.php

Around line 130 (the $users select statement), add in:

, userfield.field2, userfield.field3

where field2 and field3 are your custom fields (keep adding for additional fields).

The around like 163 (where is has the array for variables), add in extras for the fields above. You can name them $field2 and $field3, or name them something easier to remember ($address and $zipcode, for example).

Then on like 164 where it is selecting the values for the above, add in your fields at the end (i.e. $user['field2'] and $user['field3']).

After that, save and you can now use the variables in your emails!

Here are the snippets from my file so you can see what it looks like all together. I've made my additions red:

Lines 129 & 130:

SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
useractivation.activationid, userfield.field2, userfield.field3

Line 163:

array('$email', '$username', '$userid', '$field2','$field3'),

Line 164:

array($user['email'], $user['username'], $user['userid'], $user['field2'], $user['field3']),