|Why don't you create a distribution list with all of the email addresses and use the list in the BCC field?|
Each recipient will receive an email that looks like it is addressed only to them.
As long as your email app will allow you send an email to 1000 people at one time, you'll only need to send 1 email, not 1000.
If not, create smaller distribution lists, up to limit that your app will allow.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.