Using Outlook from Excel

Status
Not open for further replies.
B

BillCPA

I have a subroutine in Excel that sends out e-mails in Outlook. Works

perfectly, except that it doesn't use my standard layout (style) nor does it

insert a signature. Can anyone help me get that to work?

Bill @ UAMS
 
Calling Getinspector on the MailItem inserts the sig.

Best regards

Michael Bauer

Am Wed, 20 Jan 2010 15:56:01 -0800 schrieb BillCPA:


> I have a subroutine in Excel that sends out e-mails in Outlook. Works
> perfectly, except that it doesn't use my standard layout (style) nor does


it
> insert a signature. Can anyone help me get that to work?
 
Just make sure you don't overwrite it when you set the Body or HTMLBody

property

Sue Mosher

"Michael Bauer " <mb@mvps.org> wrote in message

news:6dciqwd5phoz.kc8jbymsw7z1.dlg@40tude.net...

> Calling Getinspector on the MailItem inserts the sig.

> > Best regards
> Michael Bauer
>

>

> Am Wed, 20 Jan 2010 15:56:01 -0800 schrieb BillCPA:
>
> > I have a subroutine in Excel that sends out e-mails in Outlook. Works
> > perfectly, except that it doesn't use my standard layout (style) nor does

> it
> > insert a signature. Can anyone help me get that to work?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
S Find a cell value in excel using outlook vba Using Outlook 1
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
M Outlook 2013 won't convert Excel contacts into Outlook contacts using my custom form Using Outlook 3
M VBA Send Sales reports using .oft files, originate in Outlook or Excel? Using Outlook 5
W Using Excel UserForm from Open Workbook in Outlook VBA Outlook VBA and Custom Forms 5
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 10
e_a_g_l_e_p_i Outlook 2021 not letting me setup my Gmail using pop Using Outlook 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Outlook replies not using "delivered to" address in From Using Outlook 1
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
B query outlook using vba Outlook VBA and Custom Forms 13
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
S Outlook [Online - Office365] perfomance is getting affected when accessing the mails using Redemptio Using Outlook 1
M Using Outlook with Yahoo email Using Outlook 6
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
R Using Multiple Accounts in Outlook Using Outlook 3
P MS OFFICE 2013 - Outlook locking up when using the sent on behalf of feature in VB Using Outlook 3
Diane Poremsky Using Outlook Links Using Outlook 0
Diane Poremsky Using Arrays in Outlook macros Using Outlook 0
Diane Poremsky Using the Outlook Calendar Template Using Outlook 0
N Going Forward: Using Outlook 2016 for RSS Feeds Using Outlook 2
Diane Poremsky Using Scanpst in Outlook Click to Run Using Outlook 0
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Using Outlook's New Contact Cards Using Outlook 0
J Outlook 2013 how to convert 2013 OST file into an another format, i m using outlook 2013 versions. Using Outlook 1
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
S using script rule to save attachments on arrival Outlook 2010 Outlook VBA and Custom Forms 9
Christian Using Outlook's New Contact Cards Using Outlook 4
Diane Poremsky Using Outlook's AutoArchive Feature Using Outlook 0
M Trouble using keyboard shortcut for color categories in Outlook 2016 Using Outlook 3

Similar threads

Back
Top