![]() |
#1
|
|||
|
|||
![]()
I have used a Macro called EmailMergeWithAttachments which was brought to my attention last year by macropod when he referred me to http://word.mvps.org/FAQs/MailMerge/...ttachments.htm which was created by Doug Robbins. This has worked on my computer which runs Windows XP. But when I try to run it on a laptop which is running on Windows 7 it throws up an error at "Dim oOutlookApp As Outlook.Application" - see the first section of the Macro below.
Is there any obvious reason why this Macro won't work on a laptop running Windows 7? Is this a known gremlin when you upgrade? Can anything be done to make it work in Windows 7? I would appreciate some guidance. Code:
Sub emailmergewithattachments() Dim Source As Document, Maillist As Document, TempDoc As Document Dim Datarange As Range Dim i As Long, j As Long Dim bStarted As Boolean Dim oOutlookApp As Outlook.Application Dim oItem As Outlook.MailItem Dim mysubject As String, message As String, title As String Last edited by macropod; 09-30-2013 at 02:15 PM. Reason: Added code tags |
Tags |
emailmergewithattachments, macro, windows7 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
macro works on windows, not on mac | iiiiifffff | Word VBA | 2 | 04-03-2013 12:42 PM |
![]() |
longee | Office | 1 | 11-19-2012 05:56 PM |
![]() |
Chayes | Excel Programming | 1 | 07-15-2012 09:05 AM |
![]() |
tinfanide | Excel Programming | 5 | 12-03-2011 12:53 AM |
previewer for Windows 7 | Aiken_Bob | Outlook | 0 | 05-01-2011 05:24 PM |