R
rfhall50
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 = "(e-mail address removed)"
.Body = "Here we go"
Rem .Send
End With
End Sub
--------------------
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 = "(e-mail address removed)"
.Body = "Here we go"
Rem .Send
End With
End Sub
--------------------