Firstly - thank you again, Graham. This is almost excaly what I needed
However, after giving this code a test run, there are 2 things which I don't know how to fix:
1. When saving as PDF, it seems that the "Sales sum" is not captured in the PDF that the code creates.
2. The code creates "open drafts" of all the emails, and outlook is now wating for me to hit the send button for each and every one of them.
I can appreciate the logic of verifying each eamil prior to sending, but this is something I really wanted to avoid.
I hoped the code will "fire" the "send" command, and the whole things wil happen automatically behind the scenes :-)