Receiving a Compile Error "Invalid Use of Property"

[XLA]

Hi,

I'm new to VBA and am creating a macro to generate an email in outlook. When I click the button to use the macro, I'm met with an error: "Compile error: Invalid us of property."

The first line item of the procedure is what is being highlighted. Any help for resolving this would be greatly appreciated.

Thanks,
XLA

 

[TedX]

Hi,

I'm new to VBA and am creating a macro to generate an email in outlook. When I click the button to use the macro, I'm met with an error: "Compile error: Invalid us of property."

The first line item of the procedure is what is being highlighted. Any help for resolving this would be greatly appreciated.

View attachment 81072

Thanks,
XLA

Hi XLA, I've never tried it personally, but I hunted around and found this, it might be useful to you, of course change the e-mail address to your own for testing.

 

[XLA]

Hi XLA, I've never tried it personally, but I hunted around and found this, it might be useful to you, of course change the e-mail address to your own for testing.

View attachment 81074

Hi TedX,

I used what you provided above and had a similar issue. But looking at what I inputted before, I saw that later in my script, instead of an "=" I had a "-". After I fixed that, it ran without a problem.

Thanks!

 

[TedX]

Hi TedX,

I used what you provided above and had a similar issue. But looking at what I inputted before, I saw that later in my script, instead of an "=" I had a "-". After I fixed that, it ran without a problem.

Thanks!

Great to hear mate, well done