importing email address list from excel

Status
Not open for further replies.

mikeh

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi there,

Right, I'm keen to import my mailing list of 2700 or so into Outlook and operate the monthly newsletters etc from there. Mailing list is in an Excel/csv format.

Two questions -

1) How to import this list? Trying the import function through outlook.com / contact / import brings up a pop-up box, I select my csv file of email addresses, but get the error message "you must provide a value for this property"

2) If I am able to import this list, can I import directly into a group or separate contact list? (I don't fancy having to select my 2700 mailing list members out of the 'all contacts' list)

Any advice much appreciate.

Thanks v much

Mike
 

urigagrin

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
How it is possible to import email address list from excel. I also want to import that. My email list become very large.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The easiest way to import contacts is to export the contacts folder from Outlook to get the field names - make sure the name match the correct columns then import into Outlook.

However - since you want a Contact Group, you can open the CSV in Excel, copy the address column and paste it into the members field of a Group Contact. Create a Contact Group to quickly send email to a multiple people - Slipstick Systems

Alternately, and somewhat easier to manage is to import the addresses as contacts and assign a category (add the category in excel before importing). Use a group by category view and select the category group to send them email.
 

mikeh

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thanks Diane, the copy and paste job into the members field did the trick, very much appreciated.

Mike
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Importing Thunderbird email to outlook Using Outlook 2
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
O Importing Mbox - anyone out there having experience with this tool... Using Outlook 3
D Importing Outlook Categories from another domain (Exchange 2016/Outlook 2016) Using Outlook 4
B Importing business card into Outlook for SIgnature Using Outlook 1
S Importing Ribbons Not Saved Using Outlook 7
V importing appointments to non-default calendar? Using Outlook 1
Diane Poremsky Importing Lists from Excel to Outlook New Slipstick.com Articles 0
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
Christopher M Importing from Eudora Update Using Outlook 5
Christopher M Importing from Eudora Using Outlook 7
N Importing Google contacts from CSV file removes recipient names in autocomplete list Using Outlook 0
S Importing emails to contacts Using Outlook 3
Z Importing PST files from Outlook 07 to Outlook mac Preview Using Outlook 1
Z how to make OL (2007) to use custom contact form when importing / opening .VCF? Using Outlook 1
K Importing appointment body from excel in outlook 2010 Using Outlook 1
A Importing too many emails from Gmail Using Outlook 2
J Importing to the correct calendar from Excel 2010 to Outlook 2010 Outlook VBA and Custom Forms 2
S Possible to link to ics file without importing? Using Outlook 4
L Importing Opportunities in to BCM 2013 BCM (Business Contact Manager) 0
K New to BCM - trouble importing contacts & accounts BCM (Business Contact Manager) 3
LarryH Importing csv file to custom form/fields? Using Outlook 3
T Importing Excel 2010 data into Outlook Calendar 2010 Using Outlook 12
W Importing .pst from Outlook 2010 (Win7) to Outlook 2013 (Win8.1) Using Outlook 2
V Importing Rules in Outlook 2013 Using Outlook 2
D Importing custom fields into custom form in BCM BCM (Business Contact Manager) 1
V Problem not having Contacts folder after importing emails from Yahoo. Using Outlook 0
O Importing contacts from CSV, comma delimited Using Outlook 7
B importing Outlook from a backup on an external hard drive Using Outlook 5
M Trouble Importing folders from Outlook 2007 to Outlook 2013 Using Outlook 12
wallisellener BCM 2013 importing contacts from CSV file BCM (Business Contact Manager) 8
T BCM not importing address BCM (Business Contact Manager) 1
T Importing OE6 e-mail to Outlook via Store Folder Using Outlook 9
A Trouble importing data to radio buttons Business Contact Manager 2010 (BCM) Using Outlook 2
H Importing Windows Live Mail Contact into Outlook 2010 Using Outlook 0
T Limit on importing Inbox mail from OE6 Using Outlook 16
Commodore Importing RSS on another computer (and feed locations) Using Outlook 8
O Importing pst, archive pst and address not working Using Outlook 17
N lose conditional formatting when importing to Outlook 2010 Using Outlook 2
C dates missing when importing emails Using Outlook 5
I Importing Outlook form into calendar folder? Using Outlook 1
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
K Importing CSV contacts- doesnt allow me to map or move forward V 2007 Using Outlook 1
G Importing Excel contact data base into Outlook Using Outlook 1
V Importing .pst file Using Outlook 1
L Importing multiple record from .vcf (vCard) file Using Outlook 5
M There was a problem importing your contacts. (Online with Hotmail) Using Outlook 1
S Importing outlook express backup into outlook2010... how to do it? Is it possible? Using Outlook 2
S Importing a PST file into Office 2003-OPEN WITH using Microsoft 2007!! Using Outlook 1
E Importing to Calendar from Excel Using Outlook 6

Similar threads

Top