![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I have an email that I send often, just with some variable information. I would like to have a macro that creates the base information, then leaves the email open for me to change the variable parts. I tried using the basic vba formats then commenting out the .SEND to hopefully leave the email unsent - No Luck. Any ideas how I can leave it partly filled in, but unsent ?
Thanks. The code I used is shown below. Bob Code:
Sub Badge() Set OutProg = CreateObject("outlook.application") Set OutM = OutProg.CreateItem(OlItemType.olMailItem) With OutM .Subject = "Just testing." .To = " .Body = "Here we go" Rem .Send End With End Sub |
Ads |
#2
|
|||
|
|||
![]()
If this is running in the Outlook VBA project then use Application and don't
create a new Application object. Comment out the Send() call and call the Display() method of the new mail item. -- 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 "rfhall50" wrote in message ... I have an email that I send often, just with some variable information. I would like to have a macro that creates the base information, then leaves the email open for me to change the variable parts. I tried using the basic vba formats then commenting out the .SEND to hopefully leave the email unsent - No Luck. Any ideas how I can leave it partly filled in, but unsent ? Thanks. The code I used is shown below. Bob Code: -------------------- Sub Badge() Set OutProg = CreateObject("outlook.application") Set OutM = OutProg.CreateItem(OlItemType.olMailItem) With OutM .Subject = "Just testing." .To = " .Body = "Here we go" Rem .Send End With End Sub -------------------- -- rfhall50 |
#3
|
|||
|
|||
![]()
Ken ...
Thank you for the reply. That is just what I needed. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Base input | JeffinLittleton | Outlook - Using Contacts | 1 | March 26th 09 12:25 AM |
reset or revert Outlook autocomplete email address data base | [email protected] | Outlook - Using Contacts | 3 | October 24th 07 05:01 AM |
Enable access to Contacts d/base when typeing address in an email | Peeyush Gupta | Outlook - Using Contacts | 1 | March 1st 07 11:06 AM |
Outlook installed base | Frank S | Outlook - General Queries | 3 | January 31st 07 06:53 PM |
OE 6 Data Base Q | nick | Outlook Express | 1 | December 31st 06 03:57 AM |