User Profile
Wilkinsonldw
Copper Contributor
Joined Mar 07, 2023
User Widgets
Recent Discussions
Email automation not working please help lol
Good afternoon, I was wondering if someone could please help me with this - I'm an excel novice and have put together code to extract data from 4 separate cells and bring it into an outlook email for me. I thought I'd done it correctly but every time I try to trigger the mails I get the 424 error object required and my 'objMail.Body' entire section is highlighted in yellow - would anyone be able to help at all please? I can also post the spreadsheet that I'm trying to use too. Code I've put together is below - And the spreadsheet format looks like this with 25 cells per column - With the Email Addresses kept on a separate tab. Many thanks in advance for any help!
