View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Project manager Project manager is offline
external usenet poster
 
Posts: 3
Default Opening Outlook from Excel VBA

I'm trying to setup a command/macro in an Excel VBA file that would allow me
to send email from my Excel file. When I press on the command button the VBA
syntax page opens than Excel freezes. I use the following in order to go and
get Outlook. Is this right? Any idea why Excel would freeze?

Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem
Dim ToContact As Outlook.Recipient

Thanks to anyone who can help me out!