Question Importing users

[ExpressVB]

Fillip H.

How do I make all users automatically subscribed in the list?
I tried ticking auto subscribed to the usergroups but it wont appear on the subscribed list.

If it isnt possible, can you give me the sql query to make all users set as subscribed to a mailing list?

Thanks!

 

[Fillip H.]

Auto subscribed only works if it's ticked during the creation of the mailing list. At all other times, it will only apply to new users.

 

[ExpressVB]

Fillip H.

I cant make all users subscribed to the list.

Can you give me the sql query to make all users set as subscribed to a mailing list?

Thank you

 

[ExpressVB]

Fillip H.

Can you look on this?
Can you give me the sql query to make all users set as subscribed to a mailing list?

 

[Fillip H.]

What's your mailing list ID (mouse over the Edit link in the ACP) and do you use a table prefix (find it in config.php)?

 

[ExpressVB]

Fillip H.

Mailing list ID is 3.. No table prefix

 

[Fillip H.]

INSERT INTO dbtech_vbmail_subscription
(userid, mailinglistid, subscribed)
SELECT userid, '3', '1' FROM user

That should work

 

[Fillip H.]

Hello ExpressVB,

This ticket has now been closed with the status Answered.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!