Hello all - you have all been good to me. much thanks! here's another query. I have a sheet in a workbook which contains all the info I want to send in emails. it looks like this:
A B C
joe joe@email you suck
Julie Julie@email you're great
jon jon@email you're ok
I want to compile emails to each person, use the info in columns A and C in the body, and define an email subject. This worksheet just collects the data I want to send- lets call it worksheet.email. I want to put a button on the worksheet.main that I just click and it sends the emails with the data.
My office uses Microsoft exchange for emailing, but many of us use outlook. What would be the best way to send these emails with the push of a button?
All insight is much appreciated. And please let me know if I need to provide add'l info.
Thanks as always
J.
Bookmarks