How do I make a mailing list from the emails in an Outlook Inbox folder?
A colleague has an Outlook folder full of emails generated by our website when users provide an email address to access some resources they can download. We want our web developer to write this info to a database, but whilst we wait for this poor overworked dude to complete a million other tasks before adding this functionality, how can we add the users email addresses to a distribution list in Outlook without having to do it manually? The users email addresses show up in the standard ‘From’ field of the email.
NB: The email addresses are not already within ‘Contacts’ so cannot be added to a distribution list. There are many hundred emails from different email addresses and therefore adding them manually to ‘Contacts’ before creating a distirbution list would be very time-consuming.
highlight the them all then ctrl c and paste into exel as a CSV instant spreadsheet!
powered by Yahoo Answers
To create an Outlook 2000 or 2002 distribution list from a category in the Contacts folder …
1. Apply the By Category view.
2. Select all the contacts in that category.
3. Choose Actions | New Message to Contact.
4. Copy all the names from the To box on the resulting message.
5. Create a new distribution list.
6. Click Select Members.
7. Paste the names copied in Step 4 to the Add to distribution list box.
MANUAL METHOD:
Create a mail group (aka: Distribution list)
Click on CONTACTS and then the FILE drop down menu.
Select NEW > DISTRIBUTION LIST
This will then open a dialogue box that allows you to build a list of email addresses that can be given a single name (Group name or Distribution List name).
.
References :
Comment by Frostbite — January 29, 2010 @ 4:17 pm
highlight the them all then ctrl c and paste into exel as a CSV instant spreadsheet!
References :
Comment by dark_mushroom — January 29, 2010 @ 4:37 pm