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

Import e-mail addresses into OE5

Is there a way to import e-mail addresses that are in a text file, separated by commas, into OE ver 5.00.2314.1300, without having to add each email one by one?
Doll
0
Doll
Asked:
Doll
  • 2
  • 2
1 Solution
 
Neo_mvpsCommented:
Yes, you can import a CSV file into OE5.

- Start the Address Book. (WAB.EXE)
- Select File | Import | Other Address
- Select CSV

Example of an acceptable layout of just name and email address is...

Name,E-mail Address
Neo,neo@mvps.org
You,here@there.com

0
 
DollAuthor Commented:
I tried this, but I still have to handle each address to "map" it. What I have is a plain text list of e-mail addresses that I exported from an Access field. Each address is separated by a comma. I want to send each address an update on my website, sort of like an e-mail newsletter. Couldn't I just open a New Message, put one e-mail in the to box and copy all the others in the text file and paste them into the BCC field? That way I wouldn't to make up a new group and retype each e-mail address, right?
Doll
0
 
Neo_mvpsCommented:
Yes, you could do that, but you might hit a limit where your ISP sees this as spam and stop the whole process. (Some ISPs don't allow more that 50 recipients per message.)

Another thing to consider since you have Access (97/2000?) is using Word Mail Merge functionality and do a broadcast mail to the Outlook 97, 98, or 2000. (Drawbacks:  You have to have the software, message can only be plain text.  Bonus: No need to export address, fast and efficient, allows you to address each person by name and adds a personal touch since each contact gets their own copy of the message.)
0
 
DollAuthor Commented:
I talked to the people at my ISP and they said they don't block masses of e-mails going out at once from one account, altho they have a no-spamming policy. I assured the lady that this was only about 225 e-mail addresses and each was from someone who willingly gave it to me. So, thanks for the help, and you can have the points.
Doll
0

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

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