sql connection in macro

[tommy]

I need to access a list of email addresses in a db using sql, can i do
this in my macro that is sending the email? if not, whats the best way
to go about it

 

[Jake Marx]

Hi tommy,

I need to access a list of email addresses in a db using sql, can i do
this in my macro that is sending the email? if not, whats the best way
to go about it

If you don't have much VBA experience, a Database Query would be the easiest
way to accomplish your task. Go to Data | Import External Data | New
Database Query and follow the wizard to set up your query. The query
results can be returned to an Excel range, which you can step through using
code when preparing to generate the email(s).

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]