Unfortunately, that didn't seem to work. The emails just did not send.
Before I start messing with this to much a far easier way of doing this would be to have the forwarding email address in the database in full. At the moment it says John.Langer (for example) but if it was John.Langer@domain.com then it would be a straightforward matter from within the UE wizard to correct.
Bearing in mind that I have roughly 250 entries in the database, is there a MySql command that will append (if that's the right word) "@domain.com" on the end of something that's already in the record.
Append @domain.com to the end of whatevers in the column email
So it would change John.Langer to John.Langer@domain.com then move on to the next record and change Fred.Bloggs to Fred.Bloggs@domain .com and so on.
Or is that wishful thinking on my part?