Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 567
  • Last Modified:

Outlook: email address collector / mass emailer

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.

1 Solution
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.
joopvAuthor Commented:
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".
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.
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now