Hi - apologies if this has been asked before, I have searched but not found anything related. I am trying to add email seeds/sleepers (marketing team email addresses that get added to every email campaign) into CI360. There doesn't seem to be an inbuilt function for this so what I've done is created a seed list table containing name/email address/booking details etc and then loaded that into CI360. These records appear fine, and can be added to normal marketing campaigns. The issue is because the email addresses are stored outside the main email table I end up with something like this in the final export: email seed_email title forename surname email2 mr guest 1 email2 mr guest 2 seed1 mr seed 1 What I'd like to do is a coalesce to put the seed email into the email column. Has anyone managed to do this? Thanks
... View more