Outlook: email address collector / mass emailer

Posted on 2003-03-14
Medium Priority
Last Modified: 2006-11-17
I am using Office 97 / Outlook 97 (8.04.5619) (not Outlook Express) on a Win2k platform.

I sorted my sent and received emails in topic specific folders within Outlook.  Now, i want to send all persons in a specific folder an email, an announcment if you like.

How can i get:
- a list of all email addresses from my received emails per subfolder?
- convert these to 'contacts' or whatever i need.
- send all these contacts/persons an email?

Do i need another application?  I don't like to migrate to another platform for email, since i really would not like losing years of email contacts.

Question by:joopv
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8141250
If you were using Outlook 2000 or Outlook 2002, you could use VBA to get at your addresses. With Outlook 97 you would have to use VBA from another application or VB to get at your Outlook data.

Author Comment

ID: 8141551
Thanks for your reply.
In the mean time i found out that i can export the data in a mail folder to an excel or csv file, then edit the data and re-import it in the contacts folder.

Now i tried this export function but appearantly i first need to install a "valupack".
LVL 23

Expert Comment

ID: 8142188
That is on the Office97 CD.  I can't remember the exact location but you can do a search of the CD for VALUPACK and find the directory.
LVL 21

Accepted Solution

traval earned 1000 total points
ID: 8147827
Here's the "Value Pack":

Here's just the converter from the pack:

Use the same XL CSV file to run a mail merge to the people if you want the emails individualized.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question