Excel 2000 - Outlook Object Model Help

[TheShaunMichael]

I have a Macro written for Excel 2007:

Sub CreateJobEmail()

Dim WSS As Worksheet
Set WSS = Worksheets("Sheet1")
myitem = CreateItem(olMailItem)

'Creates a new e-mail item and modifies its properties
Dim objMail As Outlook.MailItem

'Create e-mail item
Set objMail = Outlook.CreateItem(olMailItem)
With objMail
'Set body format to HTML
.BodyFormat = olFormatHTML
.HTMLBody = "Please confirm receipt..."
.Subject = WSS.Cells(2,...
.CC = "shwalker@....
.Display
End With
End Sub

Can someone explain how to make this type of Macro work for Office/Excel/Outlook 2000? I'm not familiar with 2000 at all. I'm not even sure how to find the references library yet.

Thanks in advance!

 

[Norie]

Have you tried the code in other versions?

Is that all the code?

It seems to be missing something, perhaps the part that creates/finds an instance of Outlook.

 

[TheShaunMichael]

Yes I've tried it in 2000 and it doesn't work. I'm truthfully NOT experienced at all in pairing VBA with Outlook & other MS programs so you may very well be correct about missing a string that finds the instance of Outlook. Can you possibly help me out?