ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: spot on March 31, 2007, 03:47:41 pm

Title: Mass Editing Follow-ups
Post by: spot on March 31, 2007, 03:47:41 pm

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?

Title: Mass Editing Follow-ups
Post by: DW on April 02, 2007, 05:44:30 pm

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):

Quote

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