I have a list of about 1000 customers, to whom I want to send a PDF file by email (Outlook).
I do this by sending the mail to myself, and I put the customers in Bcc.
Because 1000 is too much to handle, I want the customers separated in groups of 50, resulting in 20 similar mails to send.
Can anyone help me to program this in VBA ?
Thanks in advance.
[Blocked Image: https://www.mrexcel.com/board/attachments/1617197049448-png.35681/]