Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 email addresses to outlook

Author  Topic 

Yak Posting Veteran

69 Posts

Posted - 2007-03-23 : 15:32:14
Is there a way to export a list of email addresses to outlook based on certain query conditions? So for example, lets say using pubs, I want to send out an email to a group of authors who have published only one book. So could I essentailly query for the authors and then have those corresponding authors emails sent to outlook so that I could send out a generic email asking them if they are going to write another book or something like that?

The Yak Village Idiot

Posting Yak Master

145 Posts

Posted - 2007-03-23 : 15:53:43
I don't think there is any way to pass the email ids to outlook but...
You can make use of SQL mail or Database Mail send email to all authors a generic email...
See BOL topic "SQL mail" or "Database mail"

Go to Top of Page

- Advertisement -