Outlook automatically adds my signature to the emails so I did not have to include that in the Word document.Protip: test this on yourself before sending mass emails! I also sent my test emails to different email providers (gmail, yahoo, bwa) to make sure my email is formatted the way I wanted. In the Send As field, select “Text” or “HTML message” (I chose the latter because I embedded a photo). In the To field, select the heading for the email addresses.
Mail merge from excel on a mac computer for mac#
These instructions are based on the Office 2011 for Mac version* but it should also work the same way for Windows users. This year, I decided to do a little research and get some technical assistance. Guess how many students there are? A lot! There’s 91! Last year, I had less than 20 majors to email so I edited and sent each email individually. I just received a list of newly declared majors and minors. Currently, I manage physics, astronomy, mathematics and computer science. Part of my job responsibilities is to do outreach to the new majors in the subject areas that I am responsible for.
Mail merge from excel on a mac computer how to#
I figured out how to do a mail merge! (Can you tell I’m really excited?) Mail merge allows me to send personalized emails en masse from a single template.