send file to a group of Outlook contacts

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.

The easiest way would be to loop through all customers and send the same email to each one, with the PDF attached

Not you sending each email but your VBA code handling that for you.

I can help you with that, if that's the way you want to proceed?

Thanks Croweater, but it needs to be in BCC. Otherwise I end up with having 1000 emails in the Sent folder...

Even if these 1000 can probably also be deleted automatically.

OK...here is some code for you to try.
I stress that it is only tested with a handful of emails (for obvious reasons), however I am happy to help you implementing the code if you have problems.

Please Login or Register  to view this content.

Thanks Croweater

at first glance, this seems to be a good solution ! I'll test it out after the Easter weekend and I will get back to you.

Happy Easter !

Hi Croweater

as promised I get back to you.

Here is how I solved the issue:

- first I count the total number of email addresses
- then I start a second incremental counter, which goes through the total list of email addresses
- each time this counter reaches 50, 100, etcetera then a draft mail is created.
- I loop until the counter reaches 1000.
This solved my problem. Thanks anyway for your help.

Th

OK Ali !

I'm new to this forum.

Thanks for your advice !

Sounds like you didn't need me in the first place. Thanks for wasting my time.

Basically, your solution included a "Counter" and this was the needed step towards the alternative solution I developed. So it was of great help. Thanks again.