Added (jobs): Automating Emails from Excel

[Len Piwowar]

Try This:

1)Open the Excel file with the mail macro's
2)Open Visual Basic editor expand the folder Microsoft Excel Objects
3)Double click on ThisWorkBook folder in the Microsoft Excel Objects in the current VBAproject
4)Open Module1 in modules of the project and cut the following code from the top of the module:

'Set up the Outlook objects.
Dim objOutlook As Outlook.Application 
Dim objOutlookMsg As Outlook.MailItem 
Dim objOutlookRecip As Outlook.Recipient 
Dim objOutlookAttach As Outlook.Attachment 
'Declare our global variables to be used in each subroutine.
Dim CustomerAddress As String 
Dim CustomerMessage As String

5)Paste this into item 2 from above (ThisWorkBook folder) General - Declarations
6) Save, close and Try
Hope this helps
Len