I worked on creating a mailing list for a public facing SharePoint site. I really had some constraints because I was only allowed to use SharePoint Designer and the browser. I’m not used to these situations because I am mainly a software engineer. However, it was a very nice experience. I applied lots of knowledge and I worked around the constraints. I decided to put the experience and workarounds together into an educational series of articles to help SharePoint end users and administrators create their own mailing list without writing a single line of .NET code.

In office 2007 you can synchronize the list with your contacts. Unfortunately we don’t have office 2007 so it is a bit trickier. Proceed to bulk import data, you may be able to work on multiple columns at one time but this depends on how similar your spreadsheet and list are.