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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 email addresses to outlook
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jgrant
Yak Posting Veteran

69 Posts

Posted - 03/23/2007 :  15:32:14  Show Profile  Send jgrant an AOL message  Reply with Quote
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

MohammedU
Posting Yak Master

USA
145 Posts

Posted - 03/23/2007 :  15:53:43  Show Profile  Reply with Quote
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"


MohammedU
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000