Cardbox > Forums > Macros and Programming > "Macro Works on Some Machines, but Not on Others"
Macro Works on Some Machines, but Not on Others
Bulk email command cannot open outlook. |
Posted By | Post |
---|---|
Voices4Wellbeing | 11-Oct-2011 12:52 I was given a macro by the wonderful Bert on here to do bulk emailing. It works like a dream on my computer, and a couple of others within this office. However, it does not work on two computers. Not sure if this is an OS issue, as it works on the computers running Windows 7 but not on the ones running XP or Vista. The Error message on computer running XP: "Command Failed. The specified module could not be found (8007007E). (Position in the macro - Line 45, Character 1)" Error message on computer running Vista: "ActiveX Componant can't create object: (Outlook Application) (Position in the macro - Line 45, Character 1)". The offending line in the macro is: Set Outlook = CreateObject("Outlook.Application") The full macro is: 'number of max addresses in bcc 'you can also pickup this here from a txt file. Do not forget that a vbcrlf or lf must be translated to <br> 'the subject of your mail dlg = GetOpenFilenames("All Files|*.*","","select files (use > 1 ctrl+click!)",cbxGetFilenamesWithPanel) set em = Records 'make an array of x 'generate a email after 49 addresses 'the last addresses '=================================================== .Display |
bert | 11-Oct-2011 13:33 Wonderful that MicroSoft. I remember I had the same on one XP Pro HP-pre-installed notebook ever. This is a what worked in my case: ..... I Hope this will help you. regards |
Voices4Wellbeing | 11-Oct-2011 14:13 Thank you very much for your help bert, but I am still getting the same error messages. I changed my macro so the end looks like this: 'the last addresses '=================================================== With Msg .Display |
Voices4Wellbeing | 11-Oct-2011 14:14 It still says the error is the Set Outlook = CreateObject("Outlook.Application")line |