Object out of range VBA error?

[Jyggalag]

Hi all,

I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error:

and debug highlights this:

Did I not do it correctly? What do I need to fix?

Thank you all!
BR.
Jyggalag

 

[RoryA]

You never created the email in the first place.

 

[BSALV]

With outapp instead of Outmail ???

??? .to = ws.range("A64").value ???

what's the content of A64

 

[Jyggalag]

With outapp instead of Outmail ???

??? .to = ws.range("A64").value ???

what's the content of A64

A64 is simply just a cell value containing "test@mail.com"

 

[Jyggalag]

You never created the email in the first place.

What do I need to edit?

I ask it to .Display in the end of the vba code

 

[RoryA]

You're missing:

Set outmail = outapp.createitem(0)

or similar.