Thread: how to write excel in macros through which mail has to be sent via outlook
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default how to write excel in macros through which mail has to be sent
go to the VBE, Alt+F11, then go to tools-References and find Microsoft
Outlook in the listing. Click the checkbox to create a reference to it.
Then Excel will understand those declarations.

--
Regards,
Tom Ogilvy


"sam" wrote:

Hi Carim,

I went in to the site, but few functions were not working in my system.

Ex: Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem

How do i proceed?

Thanks
Sunil


Reply With QuoteReply With Quote