# So how do I get these addresses in the TO box in Outlook?

**URL:** https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670
**Category:** Factual Questions
**Created:** [October 21, 2003, 10:37am UTC](https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670 "2003-10-21T10:37:10Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Pushkin](https://avatars.discourse-cdn.com/v4/letter/p/ee59a6/32.png) [@Pushkin](https://boards.straightdope.com/u/Pushkin)
#### Post date: [October 21, 2003, 10:37am UTC](https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670/1 "2003-10-21T10:37:10Z")

</div>

I have an Access database set up to take details of people asking for information from our office. To let them know we’re sending stuff out I need to send a mass email to everyone whose applied, 60 odd people, and I don’t want to type each individual email address in the TO or CC box. Is there anyway to take all the email addresses out of the database somehow and paste them into Outlook?

Thanks  
Pushkin

---

<div class="post-metadata">

### Author: ![Liberal](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@Liberal](https://boards.straightdope.com/u/Liberal)
#### Post date: [October 21, 2003, 11:00am UTC](https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670/2 "2003-10-21T11:00:48Z")

</div>

Just use Outlook’s import feature. File -\> Import and Export… -\> Import from another program or file -\> Microsoft Access

---

<div class="post-metadata">

### Author: ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)
#### Post date: [October 21, 2003, 11:50am UTC](https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670/3 "2003-10-21T11:50:32Z")

</div>

You could generate and send the emails directly from Access, either using a macro or some VBA code.

---

<div class="post-metadata">

### Author: ![Pushkin](https://avatars.discourse-cdn.com/v4/letter/p/ee59a6/32.png) [@Pushkin](https://boards.straightdope.com/u/Pushkin)
#### Post date: [October 21, 2003, 4:36pm UTC](https://boards.straightdope.com/t/so-how-do-i-get-these-addresses-in-the-to-box-in-outlook/208670/4 "2003-10-21T16:36:58Z")

</div>

Cheers, I think tho’ I’ll try the Import/Export first, I’m not too up on macros and the like yet.