Hi I have a spreadsheet of 400 names, positions and e-mails which are constantly being updated. I can sort using the filters to get manager, technician etc. Each name has an e-mail in a separate column.
So I can then mail groups of people or all of them as needed I need to extract the e-mail addresses and get them into the format fredbloggs@gmail.com;susanbloggs'gmail.com;henrybloggs@gmail.com
i.e all separated by a semi colon.
Can anybody tell me an easy way of doing this?
many thanks
Mark
So I can then mail groups of people or all of them as needed I need to extract the e-mail addresses and get them into the format fredbloggs@gmail.com;susanbloggs'gmail.com;henrybloggs@gmail.com
i.e all separated by a semi colon.
Can anybody tell me an easy way of doing this?
many thanks
Mark