If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using email addresses from an Excel spreadsheet?
Hello, I have a TON of email addresses contained in an Excel spreadsheet. I
would love to be able to just cut and paste (or something similar) them into an email that I need to send. Is this possible? Thanks in advance, jan |
#2
|
|||
|
|||
Using email addresses from an Excel spreadsheet?
You would have to convert the xls worksheet into CSV format, making sure
that it is in the following format as regards the appropriate columns and that CSV file can then be imported into the Address Book (note that the comma is a separator for respective columns): First Name,Last Name,Middle Name,Name,Nickname,E-mail Address,Home Street,Home City,Home Postal Code,Home State,Home Country/Region,Home Phone,Home Fax,Mobile Phone,Personal Web Page,Business Street,Business City,Business Postal Code,Business State,Business Country/Region,Business Web Page,Business Phone,Business Fax,Pager,Company,Job Title,Department,Office Location,Notes -- Jim Pickering, MVP, Outlook Express https://mvp.support.microsoft.com/pr...8-1171988A62D6 Please deliver feedback to the newsgroup, so that others can be helped. "Jan" wrote in message ... Hello, I have a TON of email addresses contained in an Excel spreadsheet. I would love to be able to just cut and paste (or something similar) them into an email that I need to send. Is this possible? Thanks in advance, jan |
#3
|
|||
|
|||
Using email addresses from an Excel spreadsheet?
Are you wanting the addresses in the To field.
Highlight the addresses, Copy, Paste. Note: most ISPs limit the number of addresses in any field. 25 is probably the limit. Note: put the addresses in the Bcc field and your address in the To field. Are you wanting someone to have the addresses? Save as a csv file and send the file. -- Ron Sommer "Jan" wrote in message ... : Hello, I have a TON of email addresses contained in an Excel spreadsheet. I : would love to be able to just cut and paste (or something similar) them into : an email that I need to send. : : Is this possible? : : Thanks in advance, : jan |
#4
|
|||
|
|||
Using email addresses from an Excel spreadsheet?
"Jan" je napisal v sporočilo ... Hello, I have a TON of email addresses contained in an Excel spreadsheet. I would love to be able to just cut and paste (or something similar) them into an email that I need to send. Is this possible? Thanks in advance, jan |
Thread Tools | |
Display Modes | |
|
|