Hi Apo,

May I call upon your expertise one more time in this matter?
A small additional (and quite easy) change is needed.
The macro you created in the above 'mail file.xlsm' works perfectly. However, can it be changed that the mail is created only when the cell in column D on the tab "HUB outbound HTM daily report" contains data?
So when cell D2 is empty, no mail is created, when D2 isn't empty, a mail is created for line 2? In the attached file, it should create 4 mails, for lines 2, 3, 4 and 6. Then it should put a 1 in column AQ (as per the current macro). When cell D5 is filled, it should then create a mail for that line, and put a 1 in column AQ for that line etc...

So basically it should be some kind of check that if column D is filled, it should run the macro for that line, if not, it should skip to the next line.

Would that be possible? I've no idea where in the code I should enter such check...

Thanks again!!!
Peter