Email list from Access to Outlook: How?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Paul Brady

    Email list from Access to Outlook: How?

    This must be a common operation, but I have searched this newsgroup
    and have wrestled with the help messages, and I seem to need help with
    this simple task.
    I have an Access 2000 database which, via a query, can
    generate a list of e-mail addresses. I can export this list, if
    necessary. There may be hundreds of names in this list.
    Now, I want to send e-mail to everyone on this list. I can
    copy the list onto the clipboard (all 300 names!) and jam it into the
    Outlook address field (Ugh!), but what I really want is for Outlook to
    simply send the email to everyone on the list.
    Can someone point me to a FAQ or tutorial on how to get
    Outlook to send the email to everyone on the Access-generated list? I
    have figured out how to populate an Outlook address book with this
    list, but once again, I don't want to put all 300 names from the
    address book into the email address.
    Thanks very much. Pete Brady
  • Tony Toews [MVP]

    #2
    Re: Email list from Access to Outlook: How?

    Paul Brady <ptbrady@aol.co mwrote:
    > Can someone point me to a FAQ or tutorial on how to get
    >Outlook to send the email to everyone on the Access-generated list? I
    >have figured out how to populate an Outlook address book with this
    >list, but once again, I don't want to put all 300 names from the
    >address book into the email address.
    See the Outlook specific links at the Access Email FAQ at my website.


    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at

    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

    Comment

    Working...