Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


why can I not see my macros in mail message

Posted on 2009-05-09
Medium Priority
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
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
  • 5
  • 3
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 200 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 800 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.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Mailbox Overload?
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

730 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