E-mail Script to handle duplicate E-mail addresses

Hi there,

I am trying to get my co-worker set up for E-mailing .pdf Statements to customers every month. I created a script for this which works just fine, except for the fact that if several statements have the same email on it, it will send multiple emails to the same recipient.

I've attached my script. I realize that my If statement is way off the mark, but what I was trying to say is if the script finds a duplicate email, send the invoices as "records being browsed" so that those statements are sent as one, continuous, multi-page .pdf attachment to that recipient, rather than that recipient receiving multiple emails of one page statements. Otherwise, send only the "current record" if there are no duplicate emails / one recipient. I hope this makes sense. Does any one have any suggestions? Thank you ahead of time!