Thanks Jyoti. Yes, the prepare deliveries permission is granted.I actually found what the problem was. The preview was trying to use a recipient from the main recipient folder for which the account has restricted access for. I switched to group of recipients in a test Recipient folder and have full ...

Thanks to everyone who replied. I was on leave and could not reply back until now. Since it was an urgent request at the time by our stakeholders I had to make it work on the same day as that was my last day before going into leave. So I moved the logic to the workflow itself as that was the quickes...

Thanks a lot David, I will check it out now. Cheers

Thanks MilanNever had used the SQL activity, so that was an easy one. Thanks for the quick reply

Thanks Craig.. make sense! Cheers

Hi Prem KumarThanks a lot for your prompt response, that's great news