Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2010, 01:20 PM
Engywook Engywook is offline Moving email addresses in bulk to an address book Windows XP Moving email addresses in bulk to an address book Office 2007
Novice
Moving email addresses in bulk to an address book
 
Join Date: May 2010
Posts: 1
Engywook is on a distinguished road
Default Moving email addresses in bulk to an address book

Supposing I had a list of email addresses in an Excel spreadsheet, which I pulled from a database. I need to do a mail merge with each of these email addresses, such that each recipient only sees their own email address in the To: field.



I do have each of these email addresses in my contacts (I think), because each of them has sent an email to me. But I think I also need to get them into a distribution list.

Is there any way I can populate this distribution list by grabbing them all of them at once, from Excel, and pasting them in? It appears that every option offered by Outlook requires doing it one. address. at. a. time. And it's a hundred email addresses... could be a thousand next time. What to do?
Reply With Quote
  #2  
Old 05-19-2010, 05:30 PM
Kimberly Kimberly is offline Moving email addresses in bulk to an address book Windows 7 Moving email addresses in bulk to an address book Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Is there some reason you want a distribution list? You cannot use a dist list as the data source for a mail merge. You can use the Excel file as the data source or, if you want the email addresses to be in Outlook, you can import the Excel file to a subfolder in Contacts and use that subfolder as the data source.
Reply With Quote
  #3  
Old 05-19-2010, 05:32 PM
Kimberly Kimberly is offline Moving email addresses in bulk to an address book Windows 7 Moving email addresses in bulk to an address book Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Of course, if you decide you don't care about their email address being in the To box, you can skip the mail merge and just use a dist list to fill in the Bcc box instead of the To box.
Reply With Quote
Reply

Tags
contacts, distribution list, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How would I bulk select and copy highlights and then bulk paste them automatically? copywriterpro Word 0 04-19-2010 05:21 AM
address Book files MervNorton Outlook 0 03-29-2010 07:44 AM
Moving email addresses in bulk to an address book can't see address book keithsibille Outlook 1 12-28-2009 09:07 AM
How Many Email Addresses Can You email at one time in Outlook zinfandel72 Outlook 2 08-04-2008 06:39 AM
Moving email addresses in bulk to an address book Re-installing Outlook, moving .pst file. but no address book brucek Outlook 1 08-31-2007 08:24 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft