Get Infinite Campus E-mail Addresses into Outlook Mailing List

Step By Step Instructions for Getting E-mail Addresses from Infinite Campus into an Outlook Mailing List:

1. Copy data & Paste into Excel
2. In Column G, cell 1 paste this formula: =IF(FIND("@", B1), B1 & "; ")
3. Drag the bottom right corner down the G column until you reach the end of your data
a. You will get an error for rows that do not have an e-mail address. This is normal.
4. In Column H, cell 1 paste this formula: =IF(ISERR(G1), "", G1)
a. Select this cell and double click on the bottom right corner to expand the formula to match column G, or you can drag the bottom right corner to the end of your data.
5. Go to the bottom of Column H after the last e-mail address
a. Paste this formula: =CONCAT(H1:H###)
i. Replace ### with the row number of the last e-mail address
6. You will now have a cell with all of the e-mail addresses formatted for Outlook.
7. Select and copy this final cell.
8. Go to Outlook and follow these steps:
a. Contacts
b. New Contact Group
c. Add Members
d. From Outlook Contacts
e. Paste into the Members field at the bottom of the dialog box
f. Click OK
g. Name your new mailing list
h. Save & Close

Mailing