Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

why can I not see my macros in mail message

Posted on 2009-05-09
Last Modified: 2012-05-06
I am using a order entry software program that sends email updates to our clients of their order status.  A Microsoft Outlook email is created with text & launched when a button is pressed in the software.  However, I would like to create a macro that would add some text to the standard email format created by the software program.  Once the email is created & launched - I can not see any of the macros that I have created in my outlook.  Why would that be.

Would really appreciate any help you can provide.
Question by:vbwanted
  • 5
  • 3
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 50 total points
ID: 24345286
Hello vbwanted,

If you are using Word as your email editor, then your Outlook macros will not be visible in your new message


LVL 59

Accepted Solution

Chris Bottomley earned 200 total points
ID: 24345321
Hello vbwanted,

If your appliocation is creating the email do you know the mechanism i.e. if you send it does it appear in your outlook sent items folder?


Author Comment

ID: 24345365
Thanks Patrick - am not using word as our email editor.
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.


Author Comment

ID: 24345370
Thanks Chris,

When we send the email - it does appear in our sent items.
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24345395
PLease excuse me questioning you!

WHere you say your outlook macros are not visible, can you supply a sample and define the module in which the macro resides, normal module or class module for instance.


Author Comment

ID: 24345416
I know nothing about macros in outlook - how would i know if it is a normal module or class module

here is the macro that I was given by another user on this website...

sub addtoeMail()
Dim maiNew As Outlook.MailItem
Dim maiOrig As Object
Dim str As String
    If TypeName(Application.ActiveWindow) = "Explorer" Then
        Set maiOrig = Application.ActiveExplorer.Selection.Item(1)
    ElseIf TypeName(Application.ActiveWindow) = "Inspector" Then
            Set maiOrig = Application.ActiveInspector.CurrentItem
        Exit Sub
    End If
    If Not maiOrig Is Nothing Then
        Set maiNew = maiOrig.Reply
            str = "Good Morning" & vbCrLf & vbCrLf & _
            "Thank you for giving us the opportunity to work with you.  We" & vbCrLf & _
            "recognize that our success is determined by the success of our" & vbCrLf & _
            "clients.  We thank you for trusting us with your business and look" & vbCrLf & _
            "forward to assisting you on your next order." & vbCrLf & vbCrLf & _
            "Please find below the details of your current order." & vbCrLf & vbCrLf
        maiNew.Body = str & maiNew.Body
    End If
Set maiNew = Nothing
Set maiOrig = Nothing
End Sub
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24345462

You've got two questions open, and they are overlapping at this point.  Can we concentrate on just the one thread ... the other one since that is the precursor to this question?


Author Comment

ID: 24345520
Sure - silly me, I had not noticed it was the same user helping me out.  Thanks so much.

Author Closing Comment

ID: 31579815
We didn't really finish this question - but I am trying to get it all separated into one final question....thanks for your help

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question