Evening all
I am currently playing around with the below code and wondered if someone can assist.
I am trying to send an email to the email address contained in cell H4 but when i run the below nothing happens.
The only change i have made is to the value on the "To" section.
Any ideas?
Please Login or Register to view this content.
Well, have you gone through the code step-by-step?
If it stopped working only because you change the To value then I would certainly go through the code step by step
'Not working' is non-information.
We need more to go on
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I would deactivate the On Error line so you actually get the error.
Hi Keebellah
The error i get is as per the below.
Microsoft Visual Basic for Applications
System Error &H80004005 (-2147467259).
Cheers
Dave
That doesn't tell me anything. Which line is it generated on? At what moment?
What are the references set under tools in your VBA project?
Hi Keebellah
The error is generated on the below line.
.To = ThisWorkbook.Sheets("Input Sheet").Cells(8, 4).Value
If i replaced the above line with my email address in speech marks then the macro works fine.
Cheers
Dave
What is the exact content of the cell value?
Should work so my guess the value in that cell is incorrect (not an email address) or did you place more than one email address?
You could try
Please Login or Register to view this content.
Hi Keebellah
The actual cell content is a formula which is pulling in the email address dependant on the value of another cell.
I tried the above and that also didnt work.
Thanks
Without actually seeing the content it's impossible to say.
If you say that when you enter an email address it works but not with the cell value then you'll have to check that
The error is clearly in your input not the macro, maybe passing it to a variable first?
You will have to step through the code and see what really happensPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks