Macro: Create New Message and Auto populate To Field
 

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
; ; ; ;
.

Thanks


--
geosptial
------------------------------------------------------------------------
geosptial's Profile: http://www.thecodecage.com/forumz/member.php?userid=583
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120662

Macro: Create New Message and Auto populate To Field
 

Sub MakeMail()
Dim msg as Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.To = ; ; ; " & _
; "
msg.Display
End Sub

--
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
...

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
; ; ; ;
.

Macro: Create New Message and Auto populate To Field
 

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.


--
geosptial
------------------------------------------------------------------------
geosptial's Profile: http://www.thecodecage.com/forumz/member.php?userid=583
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120662

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
; ; ; ;
.

Macro: Create New Message and Auto populate To Field
 

"Sue Mosher [MVP]" wrote:

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
; ; ; ;
.






How can I get this same thing to work, but instead of inserting email
address, I need it to insert a subject in the subject line??

Macro: Create New Message and Auto populate To Field
 

Have you looked at the Subject property of the MailItem object in the Object
Browser?

Please don't hijack other people's threads, start your own.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Chris A" Chris wrote in message
...
snip
How can I get this same thing to work, but instead of inserting email
address, I need it to insert a subject in the subject line??