View Single Post
  #4  
Old July 29th 09, 09:22 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_3_]
external usenet poster
 
Posts: 465
Default Macro: Create New Message and Auto populate To Field

If you have a message already open, return it with this statement:

Set msg = Application.ActiveInspector.CurrentItem

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"geosptial" wrote in message
...

That worked awesome. I appreciate the help. What would i have to change
to have those same emails go into the to field on a forwarded email.



"Sue Mosher [MVP]" wrote in message
...
Sub MakeMail()
Dim msg as Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.To = ; ; ; " & _
;
"
msg.Display
End Sub

"geosptial" wrote in message
...

I need a macro that will open up a new message with the TO field already
filled in with 5 email addresses. For example;

Should open new mail message. In the To Field the addresses
; ; ; ;
.





Ads