Extracting Information From Excel Spreadsheet

Terrysdelight

WaywardDriver said:

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.

That's lovely.  Thank you.

Chino

You could also use the TEXTJOIN function to do something similar by putting the formula =TEXTJOIN(",", TRUE, A1:A250) into a cell.

https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c

WaywardDriver

Chino said:

You could also use the TEXTJOIN function to do something similar by putting the formula =TEXTJOIN(",", TRUE, A1:A250) into a cell.
https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c

Must be new feature - not on my Excel 2016.

DoaM

WaywardDriver said:

Chino said:

You could also use the TEXTJOIN function to do something similar by putting the formula =TEXTJOIN(",", TRUE, A1:A250) into a cell.
https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c

Must be new feature - not on my Excel 2016.

TEXTJOIN function

Excel for Office 365 Excel for Office 365 for Mac Excel for the web Excel 2019 Excel 2019 for Mac

Heedtheadvice

Now a couple of simple methods of 'extracting' the data......but it does help if the request is put in context by explaining the whole aim.

Waywards method (or using the text function) and pasting into the BCC addresses is certainly the easiest for  one off message to one or more 'collections' of addresses.

However importing contacts ( from a csv file  or other suitable import file) could be much better for repeat emails i.e. updates (but where it is not a long term frequent need where the automation routes could be best after a set up and test period!). Once the addresses have been imported you can group them in outlook to keep the numbers of addresses on each email to within limits - be they 10, 250 or more) but also group them together in useful groupings such as abatoirs, farmers, vets, carehomes etc. It could well be different messages need sending to the disparate categories of customers!

Le_Kirk

Terrysdelight said:

General_Grant said:

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

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.

A genuine question, not having a pop at you.  What did the person you are trying to help do during normal times?  Presumably there would have been a need to contact customers all the time not just during the current crisis.  Is it possible for him/her to utilise a similar approach.  If not, then ignore me but at least I see you have now been given some good answers.

Gers

Could a distribution list be made - a tedious though one-off job? 

onomatopoeia99

Terrysdelight said:

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 ...

The person you are helping is the data controller, you are a data processor in this scenario. Most of the responsibilty falls on the data controller, they need to ensure any required consent has been given for communications of the type you are attempting to make on their behalf.

The relevant law is the Data Protection Act 2018, an act of the Westminster parliament which incorporates the GDPR provisions (the way you phrased it suggests you think EU regulations just became UK law by magic, when in fact parliament had choose to enact each one of them as UK laws).  The regulators are the ICO, which is a UK organisation.They aren't afraid to issue fines.

MothballsWallet

OP, if you're using Mozilla Thunderbird for emails, there's a mail merge add on called, oddly enough, "Mail Merge", that helps with bulk emails like this and gives you the options for setting up To, CC, BCC recipient lists and more options.
Or, I think you could set up mail merge from Excel or Word using the CSV file as the data source, but that works primarily with MS Outlook as the email software.