Hi All, Newbie on this board, but have found a lot of useful information on here so far, so thought i would pose my question for you lovely people

I have been at this for days now, so i may well be missing the obvious. I have a module which works completely fine if i hardcode email addresses within it, however as this is a report the receipients may well change, therefore i have set up a recipient list on a worksheet, Cell B2 contains the start range for the 'vaRecipTo' email addresses and Cell C2 contains the start range for the 'vaRecipCopy' email addresses. Now i did intially have my loop working but that is no longer the case and i seem to have frazzled my brain so any help on this would be much appreciated.

When my loop was working i wasn't receiving any errors, but the email was only being sent if there was a to recipient or CC recipient on there own. Otherwise, Lotus was returning a deliver failure notice which formated the 2 emails addresses like: <FirstName.Surname@Email.com, FirstName.Surname>@Email.com which obviously meant that they were not being received. I have seen many issues with this multiple recipients all over the net, but cannot seem to find anything which relates directly to my code.

Firstly i was hoping someone could help me fix my loop? Once this is done, i will hopefully be able to specify more about my original issue with the email addresses appearing wrong.

Please Login or Register  to view this content.
Thank you all in advance

Regards
Donna