This article presents the simplest way to send emails to multiple recipients in an excel email list.
Many people ask: How can I send email to multiple recipients in an excel email list. The answer depends on how robust you want the process to be. For example you may want a way of sending the same message to different recipients with each recipient's name appearing at the beginning of the message, like
Many people ask: How can I send email to multiple recipients in an excel email list. The answer depends on how robust you want the process to be. For example you may want a way of sending the same message to different recipients with each recipient's name appearing at the beginning of the message, like
(To field): johnnash@maths.com
Dear Nash,
...
Message body
...
Yours
John, President
Elite Club of California
This is the peak of robustness in emailing multiple recipients, and can be achieved only by pros or by using commercial software applications. But more often than not, we need something simple: just being able to combine the list of emails in an excel sheet separated by semicolons or commas for suitability of pasting in the 'to', 'cc' or 'bcc' field of the free email clients like Yahoo, Gmail or the likes. This is simple and straight forward.
Open the file containing the email addresses. Assume the addresses are in column 'A', and the first row is row 1, in cell 'B1', type "=A1" (without the quotes) and press enter.
Then click the next cell below (B2) and type "=B1 & ";" & A2". (without the external quotes) and press enter again.
Guess what! At this stage, you're done! All you need is to copy the cell 'B2' downwards to the last row in the list. This could be done by clicking 'B2' and hold down your left mouse button on the dot that shows at the bottom right corner of the cell when you click on it, as shown below.
You will see the 'B' column grow triangularly downward. Just copy the content of the last cell and paste it in any of the address fields. Remember if you paste it in the 'To' field, all the recipients will see all the addresses. But it may be a smart idea to paste it the 'BCC' field and just any one of them in the 'TO' field. In this case, all the addresses will be hidden to all the recipients.
I hope this is detailed enough as a guide to the simplest way to combine addresses in excel. Also this idea should be useful in some other ways for those who can 'think out of box'. Please leave your comments here if you have any. Thank you all.
