Directions on Exporting and Importing
from Excel to Outlook
One word of caution if you are sending email to groups of parents,
you might want to put the addresses in BCC field instead of the To so
that you aren't sharing the addresses with everyone. For directions on
how to do this, look
Importing an Excel List into Outlook Contacts |
Exporting a Contact List from Outlook
Import Spreadsheet Template
Importing an Excel List into Outlook Contacts
only need to do this if you already have the email typed into an Excel
Spreadsheet. If you have the addresses written down but haven't already
typed them into something, go to my directions on
how to add Contacts in Outlook and start there. If you have an
Excel Spreadsheet set up, then read on.
Right click on the
Import Spreadsheet Template and choose Save Target As and
save it somewhere on your hard drive.
Open the spreadsheet that you have already created.
Open the Import Spreadsheet Template that you just saved.
Copy the column of names from your spreadsheet and paste them into
the Import Spreadsheet Template. If you didn't separate the names
in your spreadsheet into first and last columns, then just copy the
one column and paste it into the LastName column.
Copy the email addresses from your spreadsheet
Paste them into the template in column BE (that's way over
there!) If you have two email addresses for some students, the
second address can be pasted into column BG on the template.
Save the template spreadsheet.
Then save it again following these directions.