Extracting Information From Excel Spreadsheet

Heedtheadvice

Exactly, Doam. But at least Terry has made progress!....ooops might not be Terry but his delight, better not ask

This is where we need the next more important info from "Terry"! What is the email system?

WaywardDriver

Simple approach - concatenate addresses with comma separator and copy and paste into To box but probably limit on number of recipients so may need to do 250 at a time say.
More ambitious - use VBA to send directly from Excel - easier if using Outlook - Google shows how to.
Solution depends on exact requirements e.g. one-off? same message?
Also should send as BCC to protect user anonymity.

stragglebod

If you're going to spam people, at the very least spam them using BC, not To.

Andy_L

stragglebod said:

If you're going to spam people, at the very least spam them using BC, not To.

I suspect it's a bulk email to say " we are/are not closed due to the  CV lockdown"

DoaM

Even so, using Bcc is the correct method for a bulk mailing.

General_Grant

Have those email addresses been provided for the purpose now being proposed?

a

 is a newsletter email to the members your goal which can also be personalised https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858C7D7F-5CC0-4BA1-9A7B-0A948FA3D7D3 or do you just want the email addresses

Terrysdelight

General_Grant said:

Have those email addresses been provided for the purpose now being proposed?

I don't know and I don't care under the current circumstances.  I assume you are referring to GDPR and if you are, the regulators on that, I assume the EU, can go and whistle!

I am trying to help someone who is basically doing more than his bit to keep the West Country safe.  He needs to let customers know he is still operating to carry on his business of supplying and the emergency repairing of their sanitising equipment (Industrial ultra high pressure hot steam cleaning equipment, high pressure equipment for decontamination).  The customers who need to have the equipment for example are farmers and abattoirs etc, ie, businesses that have to protect the food chain from contamination.  Then, after food chain customers, his customers include Care Homes, our elderly relatives who need even more protection from germs than the rest of the general public.

Terrysdelight

a said:

 is a newsletter email to the members your goal which can also be personalised https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858C7D7F-5CC0-4BA1-9A7B-0A948FA3D7D3 or do you just want the email addresses

Thanks, this is very helpful - especially for the future.
For now, it's just the email addresses.  His office assistant uses Outlook for emails, at a very basic level I believe.
The email addresses will only be used for BCC, ie, no-one will be able to see who the other recipients are.
I have no idea if they have a maximum sending amount.
Also, the list of email addresses has gone right down to about 2000.  

WaywardDriver

I'd be inclined to go for the simple one-off approach.
If addresses in column A enter =A1 in cell C1 say, then =C1 & "," & A2 in C2 and copy down the first 250 rows or whatever the limit on maximum number of email recipients is. Then copy cells C1:C250 to cells C251:C500 and repeat down column.
Copy and paste cell C250 into the Bcc box and send email, repeat for C500, C750 etc.