Solved

why can I not see my macros in mail message

Posted on 2009-05-09
9
181 Views
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.
0
Comment
Question by:vbwanted
  • 5
  • 3
9 Comments
 
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
window.

Regards,

Patrick
0
 
LVL 59

Accepted Solution

by:
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?

Regards,
Chris
0
 

Author Comment

by:vbwanted
ID: 24345365
Thanks Patrick - am not using word as our email editor.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:vbwanted
ID: 24345370
Thanks Chris,

When we send the email - it does appear in our sent items.
0
 
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.

Chris
0
 

Author Comment

by:vbwanted
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
    Else
        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
        maiNew.Display
    End If
   
Set maiNew = Nothing
Set maiOrig = Nothing
End Sub
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24345462
OOPS!

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?

Chris
0
 

Author Comment

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

Author Closing Comment

by:vbwanted
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
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

785 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