Hi Everyone

Im trying to output from an access query (or it can be a table but i would need to have a check against another active field in this scenario).. direct to the to: field in outlook.

I have this in place for a single field in a form using the Application.Followhyperlink function but this wont work in terms of pulling in a full list of email addresses.

So i have a Query called "AllEmailAddresses" where column 1 is "EmailAddress" and i want to have a button on a form with the click event to attach all the email addresses in that column into outlook in the to: field, semi colon in between obviously

I am very new to VB so getting this to work is proving a nightmare... can anyone else using there expertise?