Mass Editing Follow-ups

[spot]

Hello,

I am sending out a number of weekly newsletters.  These different newsletters list are almost identical with the exception of a few things in each of the different list such as the name and address.

I have about 50 follow-up for each of the list.  Is there anyway that I can change each follow-up on a list?  As an example:

I copied all of list 1 follow-up to list 2.  (about 50 of them)  The name and address in list 2 is different than list 1.  Is there any way to mass change all of the name and address of all 50 follow-up in list 2?  Or do I have to edit each follow-up one at a time?

[DW]

Shawn,

I recommend setting up a message code of the type "Custom Text" so you can quickly change values list or site-wide.

It is possible to use a custom MySQL query (using a tool like PhpMyAdmin) to do a search and replace on all followups for a list.

The command to do the replace in the "text" section of the message would be something like this (example for list 1):

UPDATE lm_follow SET content = REPLACE(content,'Original Name','Replacement Name') WHERE list = '1'

Please let me know if I can be of further assistance!

Regards