Email list from Excel

RalphVa · Dec 12, 2020

My wife and I have been putting together our neighborhood directory since no one has done one since 2012 when I was last secretary/treasurer of the HOA but had to resign due to health.

Everything is on Excel.

Going online, there are gobs of ways of converting a column of emails into an email list, but I absolutely could not find this one. Just somehow stumbled into it. You can do eveything in Excel without going online or into Word, etc.

You enter this formula into a column near where you have the email column with H2 being the email column in this case: =H2&";" This puts a semicolon at the end of the email.

Then pick a cell where you want your email list and enter this formula: =CONCAT(I2:I134) i2 to i134 happens to be where the above column was made.

Then just copy where you have this last formula into Word or Wordpad or Notepad and save as text. Copy that whole text (ctrl A to select it) and paste (ctrl v) it into bcc of an email.

I did our Christmas note list and did it the same way.

I like to put names before the emails, too. You can do this with this formula: =CONCAT(C3,"(",G3,")") The names are in C3, and email is in G3. Then just do the above formula to add a semicolon, etc.

Ralph

MossRoad · Dec 12, 2020

Mail merge using an Excel spreadsheet - Office Support

Gem99ultra · Dec 14, 2020

Now... how'd you figure that out? Very good though. I love "CONCAT" feature and use it for a lot of things. Thanks for the procedure.

Gem99ultra · Dec 14, 2020

Very efficient. Excel can now do a lot of things far simpler than 'back in the old days'.

...good time saver. Thanks.

cqaigy2 · Dec 14, 2020

Nice!

I've used concatenate in scripts on linux and powershell, handy command.

riptides · Dec 14, 2020

Yeah. A lot more fun than a calc package. Custom documents.

MossRoad said:
Mail merge using an Excel spreadsheet - Office Support

jymbee · Dec 14, 2020

Interesting-- thanks for the tip. Personally I prefer to use Excel to import into a free MailChimp account which has numerous additional options, but I can see how this could come in handy at times.

RalphVa said:
My wife and I have been putting together our neighborhood directory since no one has done one since 2012 when I was last secretary/treasurer of the HOA but had to resign due to health.

Everything is on Excel.

Going online, there are gobs of ways of converting a column of emails into an email list, but I absolutely could not find this one. Just somehow stumbled into it. You can do eveything in Excel without going online or into Word, etc.

You enter this formula into a column near where you have the email column with H2 being the email column in this case: =H2&";" This puts a semicolon at the end of the email.

Then pick a cell where you want your email list and enter this formula: =CONCAT(I2:I134) i2 to i134 happens to be where the above column was made.

Then just copy where you have this last formula into Word or Wordpad or Notepad and save as text. Copy that whole text (ctrl A to select it) and paste (ctrl v) it into bcc of an email.

I did our Christmas note list and did it the same way.

I like to put names before the emails, too. You can do this with this formula: =CONCAT(C3,"(",G3,")") The names are in C3, and email is in G3. Then just do the above formula to add a semicolon, etc.

Ralph