Email using a list on Microsoft Excel?

copy the excel table to a word document and use the mail merge feature in ms word,

if it is a one time job, type ; on the second column of the excel sheet and copy the columns together m paste it to the address field in the outlook

You can import the contacts directly into Outlook. Make sure you are in your contacts, then do File-Import and bring in your addresses like that.

Or, you can use the Mailing feature in Word to produce mail-merged emails. You don't need to copy the addresses from Excel; you will point to that list in the step where you select your addresses.

Excel won't be able to professional-actively delete information in cells. A macro is had to act on the cellular contents and not in common terms replace the value in a cellular. despite the fact that, there's a artwork-around. you may desire to: (a million) Use Conditional Formatting to "white out" the cellular in accordance with a formula which compares the value interior the cellular to values in the different sheet using the VLOOKUP function. despite the fact that, the cellular would nonetheless have a value. (2) Create a dummy column next to the place you enter the information which will teach the information while the information does not seem in yet another place. =IF(ISERROR(VLOOKUP(enter region), cellular keeps value, else cellular is sparkling) (3) Write a Macro that runs in the time of the checklist and assigns null values to cells that seem two times. variety("beginning element").go with whilst (ActiveCell.Column < xxx) whilst (ActiveCell.Row < xxx) If (ActiveCell.value(what you prefer)) Then ActiveCell = "" ActiveCell.Offset(a million, 0).go with Wend ActiveCell.Offset(-suitable + a million, a million).go with Wend