I have a spreadsheet of users. One user per row. Column A has information I'd like to email to each of the users. Some users have between two to four email addresses in their "row" of information. Let's say Column B is email address 1, Column C is email address 2, etc. Is there a way I can perform a mail merge that can be addressed "To:" the primary email address in Column B, then BBC (blind copy) the other email addresses in Columns C, D, and E?
I am using Microsoft Office 2010 on Windows 7