At the top of your outlook ribbon, choose file. choose open & export > import/export. choose import from another program or file and then click next. tip: if you are prompted to enter a password and you haven’t set a password, click cancel to move to the next window. choose comma separated values and click next.. The email addresses are now all in that cell reading across (the lf characters are gone) with the new cell still selected press ctrl-c or right-click copy go to outlook.com and press ctrl-v or right-click paste.. Send the email messages. switch to the mailings ribbon. click on the finish & merge menu and select the send e-mail messages option. from the to drop-down menu, select the field containing the email address of each recipient. in the subject text box, enter the subject line used for the email message. from the mail format drop-down menu, select the html option..
A guide to creating a mailing list in excel that can be used for a number of applications, such as email blasts and mail merged form letters.. Outlook express stores and organizes your email messages, but it cannot perform advanced analysis on them. for example, outlook cannot count the number of messages that individual customers or clients send to your business.. How to quickly convert or copy email addresses column in excel to outlook email list? supposing here is a column of email addresses, and what you need to do is copy.