Mass email users & include user profile field

[martino]

Hi there,

I'm looking for a way to mass email my users so that i can include a custom user profile field in the body of the email. Eg

Hi <Yourname>,

I see you are a <insertcustomfieldhere>....

Is there a way of doing this directly from vbulletin or would i have to run a query to get the info out and use another program to send the emails ?

Many thanks in advance

[Elenna]

Were you ever able to do this? I'd love to figure out how to do this.

[chickadee]

anyone figure this out?

[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']),

[FD929]

ty Elenna. :)