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
 
M

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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?
 
S

Sue Mosher [MVP]

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.
< Getting the attachments in MailItem | how do I work with oft files in outlook 2007 >
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
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
S Portable MS Outlook or similar using PST Using Outlook 0
S Using iCLoud Contacts for Outlook Email Using Outlook 1
R can I transfer outlook data from old pc by using .ost file instead of the .pst Using Outlook 5
P Using IMAP and EAS with outlook.com account Using Outlook.com accounts in Outlook 9

Similar threads

Top