Help me fix attached code (create Outlook email then create calendar item)

Hi,
I have tested each of the two 'Tasks' below in individual macros and they both work just fine; individually. When I combine them in to one macro, I get an error on line 33. Can anyone tell me why, and how to fix it?

I don't know a lot about writing code, so please be simplistic. Thanks in advance for the help!

Please Login or Register  to view this content.

Hi there,

Does your code have a Reference set to Microsoft Outlook nn.0 Object Library (where nn is the version of Outlook that you're using)?

In the VBA Editor select Tools > References > Microsoft Outlook nn.0 Object Library

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi,
I have no idea what any of that means; sorry.

All I know is that when I take lines 1-32 and put them in their own macro, it creates an email just like intended. When I put lines 33-47 in their own macro, it creates an Outlook appointment just as intended. However, when put both things together in one macro, I get an error on line 33.

I think it may have something to do with the fact that both sets of code have "Dim" at the start, and perhaps excel doesn't like that or something.

Originally Posted by Greg M

Hi there,

Does your code have a Reference set to Microsoft Outlook nn.0 Object Library (where nn is the version of Outlook that you're using)?

In the VBA Editor select Tools > References > Microsoft Outlook nn.0 Object Library

Hope this helps - please let me know how you get on.

Regards,

Greg M

Okay,okay, okay; you were 100% correct.

I had a test spreadsheet that had the "create Outlook Calendar Item" macro on it, and it worked fine. Then, when I copied the code to the new spreadsheet, it didn't work.

I then figured out what you were talking about, took a look, and there was a box that was unchecked "Microsoft Outlook 14.0 Object Library" (see image)

Untitled.png

I checked the box, and it worked.
It's funny because the box was not checked and I could create emails no problem, but not for calendar items.

Thanks for point out the obvious, even though it was not obvious to me!!!