Base Email

Status
Not open for further replies.
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 = "johndoe@yahoo.com"

> Body = "Here we go"

Rem .Send

End With

End Sub

------------------

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

"rfhall50" <rfhall50.47d6d5e@outlookbanter.com> wrote in message

news:rfhall50.47d6d5e@outlookbanter.com...

> 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 = "johndoe@yahoo.com"
> .Body = "Here we go"
> Rem .Send
> End With
> End Sub

> ------------------

> > rfhall50
 
Ken ...

Thank you for the reply. That is just what I needed.

Bob

rfhall50
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D auto forward base on email address in body email Outlook VBA and Custom Forms 0
D Send on behalf of does not store the base mailbox Using Outlook 0
T issue/ base and user defined contact types BCM (Business Contact Manager) 2
G Importing Excel contact data base into Outlook Using Outlook 1
S My business contact manager base cannot contact my database. BCM (Business Contact Manager) 1
R data base is stopped BCM (Business Contact Manager) 2
Rupert Dragwater How do I remove an email ending with @gmail.com Using Outlook 3
M A plug in (or method) to keep email message formatting after it expires Using Outlook 1
L VBA to Triage Incoming Email Outlook VBA and Custom Forms 0
R Legacy Outlook on Mac Email Cache Using Outlook 0
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 3
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
A Search folder and move the email Outlook VBA and Custom Forms 0
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
D Delete selected text in outgoing email body Outlook VBA and Custom Forms 0
F Graphics in email / Mac recipient garbled Using Outlook 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
G Print email attachments when hit subfolder Outlook VBA and Custom Forms 1
C Spam Email? Using Outlook 2
G Automatically delete email when a condition is met Outlook VBA and Custom Forms 1
E Save Selected Email Message as .msg File - digitally sign email doesn't works Outlook VBA and Custom Forms 1
S Email was migrated from GoDaddy to Microsoft exchange. We lost IMAP ability Exchange Server Administration 1
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
S Paperclip icon shows without attachment in email under Sent folder Using Outlook 0
B Outlook 2019 Automatically move email after assigning category Using Outlook 4
Rupert Dragwater How to permanently remove an email address Using Outlook 9
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
F Want to add second email to Outlook for business use Using Outlook 4
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
A Outlook 2019 Help with forwarding email without mentioning the previous email sender. Outlook VBA and Custom Forms 0
J Macro to send email as alias Outlook VBA and Custom Forms 0
M Shift Delete doesn't delete email from server Using Outlook 3
K Incorporate selection from combobox into body of email Outlook VBA and Custom Forms 0
L Why are some email automatically going to "archive" Using Outlook 2
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
T Problem when requesting to view an email in a browser Using Outlook 0
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
HarvMan Archive Email Manually Using Outlook 1
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
S New Email "From" box stopped working Using Outlook 0

Similar threads

Back
Top