PDA

View Full Version : Sending emails with data from cells (including bcc)



svenski79
09-02-2018, 04:47 AM
Hi all,

Apologies if this thread already exists. I've tried a bunch of different macros online but none quite suit what I want to do, are too complicated to read or just dont work!

I'd really appreciate some help. I'm learning as I go!

I've attached a spreadsheet which will basically show you what I need. Once done I can then work it into my actual project.

Any chance at having a look?

Also if possible is there a way to have it so it shows it was sent by a different email address other than the one it came from? I want replies to go to a dropbox at work, let's call it dropbox at dropbox dot com

As well, if there's a way for a dialog box to pop prior to sending with a confirmation message?

I hope I'm not asking for too much.

Take care and thanks gurus!

svenski79
09-02-2018, 01:22 PM
Crosspost here fyi
https://www.excelguru.ca/forums/showthread.php?9349-Sending-emails-with-data-from-cells-(including-bcc)

svenski79
09-02-2018, 02:06 PM
This has now been solved please disregard.