Emails from excel

P

paul

Bernie

Forgive me for jumping in on this, you seem to be the only person that
has put forward a code that works first time. I ought to mention I am
very new to all this and just getting my head round it.



The code you set out for Ken works well however there are a couple of
amendments I need to make but I'm struggling if you can help I'd be
grateful. The issues are:

How can I get the code to recognise a column rather than just one cell
and

I keep getting a debug coming up that highlights myItem.Send
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Probably simple 3
display message box in excel(2003) using VBA word(2003) 0
Adding dates within a comment 6
Open Webpage in Excel 3
Calling Outlook from within Excel 4
Same old subscript out of range error 2
Xbox Series X anomaly (sort of) 4
Vacinations ??? 4

Top