exporting from SQL to an Outlook group or Dist List?

[Francesco]

I need to export a list of name and email address fields from a SQL
table, in some format so that a user can take the file I generate and
Import it into Outlook and it will keep all the names together in a
Group or Distribution List rather than dumping them into the user's
main address book. Any ideas?

Francesco

[Simon Hayes]

Re: exporting from SQL to an Outlook group or Dist List?

"Francesco" <francesco@neur odesign.com> wrote in message
news:8b6199d0.0 307310928.73359 d1e@posting.goo gle.com...[color=blue]
> I need to export a list of name and email address fields from a SQL
> table, in some format so that a user can take the file I generate and
> Import it into Outlook and it will keep all the names together in a
> Group or Distribution List rather than dumping them into the user's
> main address book. Any ideas?
>
> Francesco[/color]

Assuming you have SQL2000, you can use BCP or DTS to create a CSV file, or a
file in some other delimited format. As to how you import that into Outlook,
you will get a better response posting in an Outlook newsgroup - there are
several microsoft.publi c.outlook.* groups.

Simon