Hi,
ive become stumped in VBA and need some help!
ive written code to export a list of email addresses from a database
and now have them in a excel sheet all down column A.

What i now need to do is put each email address in a new outlook
message, the problem is outlook only allows 20,000 characters to be put
in the To: section, i need to somehow (best way i can see it being done
maybe?) export the email addresses into notepad, add an ; after each
email and make sure the character count doesnt go over 1950, once
reached 1950 the process is looped to add other email addresses in
another mail message.

any help much appreciated :)