|
|
|
date: Fri, 14 Apr 2006 10:30:41 -0400,
group: microsoft.public.word.word97vba
back
Re: Word to Email Macro Broken By OE Securty Update
Salut, Jean-Guy. Thanks for your reply.
> Are you still using Word97 and Outlook Express from Office 97?
I'm using OE 6. Most current.
> Can you post the bit of code you use to do that (the saving as and sending
> of email)
The code goes a little like this:
===========================================
If FilName$ = "aaa.doc" Or FilName$ = "bbb.doc" Then
ActiveDocument.SaveAs FileName:="C:\Documents and Settings\All
Users\Desktop\" + IDNumName$ + ".eml", FileFormat _
:=wdFormatText, LockComments:=False, Password:="",
AddToRecentFiles:=True _
, WritePassword:="", ReadOnlyRecommended:=False,
EmbedTrueTypeFonts:= _
False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False
End If
ActiveWindow.Close
RetVal = Shell("C:\Program Files\Outlook Express\msimn.exe
/eml:C:\Documents and Settings\All Users\Desktop\" + IDNumName$ + ".eml",
vbNormalFocus)
===========================================
"Jean-Guy Marcil" <NoSpam@LeaveMeAlone> wrote in message
news:eXyfsS9XGHA.4432@TK2MSFTNGP04.phx.gbl...
> John Ciccone was telling us:
> John Ciccone nous racontait que :
>
>> I'm gonna have trouble explaining this... but my most recent security
>> updates put a newer version of msoe.dll in the Outlook Express
>> folder. Now my Word 97 macros don't work unless I replace it with the
>> older version.
>
> Are you still using Word97 and Outlook Express from Office 97?
>
>> Specifically, the Word macro takes the current document and saves it
>> as an outgoing email. But with this new msoe.dll OE opens the message
>> as a *received* email.
>
> Can you post the bit of code you use to do that (the saving as and sending
> of email)
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
date: Fri, 14 Apr 2006 12:43:23 -0400
author: John Ciccone
Re: Word to Email Macro Broken By OE Securty Update
John Ciccone was telling us:
John Ciccone nous racontait que :
> Salut, Jean-Guy. Thanks for your reply.
>
>> Are you still using Word97 and Outlook Express from Office 97?
>
> I'm using OE 6. Most current.
>
>> Can you post the bit of code you use to do that (the saving as and
>> sending of email)
>
> The code goes a little like this:
>
> ===========================================
>
> If FilName$ = "aaa.doc" Or FilName$ = "bbb.doc" Then
> ActiveDocument.SaveAs FileName:="C:\Documents and Settings\All
> Users\Desktop\" + IDNumName$ + ".eml", FileFormat _
> :=wdFormatText, LockComments:=False, Password:="",
> AddToRecentFiles:=True _
> , WritePassword:="", ReadOnlyRecommended:=False,
> EmbedTrueTypeFonts:= _
> False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
> SaveAsAOCELetter:=False
> End If
>
> ActiveWindow.Close
>
> RetVal = Shell("C:\Program Files\Outlook Express\msimn.exe
> /eml:C:\Documents and Settings\All Users\Desktop\" + IDNumName$ +
> ".eml", vbNormalFocus)
>
> ===========================================
>
Sorry, can't really help you here, never tried to use Shell to activate OE
(or Outlook) and send an email.
I have always use the default email manger on the system.
Have you had a look at
http://word.mvps.org/faqs/interdev/sendmail.htm
It may provide some answers or an alternative.
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org
date: Fri, 14 Apr 2006 15:53:02 -0400
author: Jean-Guy Marcil NoSpam@LeaveMeAlone
Re: Word to Email Macro Broken By OE Securty Update
Thank you John-Guy, but those code examples send as attachment. In any
event, it turns out that the msoe.dll problem is a known bug with this
security patch. Microsoft is aware.
Thanks again.
"Jean-Guy Marcil" <NoSpam@LeaveMeAlone> wrote in message
news:%23gcgL0$XGHA.4120@TK2MSFTNGP03.phx.gbl...
> John Ciccone was telling us:
> John Ciccone nous racontait que :
>
>> Salut, Jean-Guy. Thanks for your reply.
>>
>>> Are you still using Word97 and Outlook Express from Office 97?
>>
>> I'm using OE 6. Most current.
>>
>>> Can you post the bit of code you use to do that (the saving as and
>>> sending of email)
>>
>> The code goes a little like this:
>>
>> ===========================================
>>
>> If FilName$ = "aaa.doc" Or FilName$ = "bbb.doc" Then
>> ActiveDocument.SaveAs FileName:="C:\Documents and Settings\All
>> Users\Desktop\" + IDNumName$ + ".eml", FileFormat _
>> :=wdFormatText, LockComments:=False, Password:="",
>> AddToRecentFiles:=True _
>> , WritePassword:="", ReadOnlyRecommended:=False,
>> EmbedTrueTypeFonts:= _
>> False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
>> SaveAsAOCELetter:=False
>> End If
>>
>> ActiveWindow.Close
>>
>> RetVal = Shell("C:\Program Files\Outlook Express\msimn.exe
>> /eml:C:\Documents and Settings\All Users\Desktop\" + IDNumName$ +
>> ".eml", vbNormalFocus)
>>
>> ===========================================
>>
>
> Sorry, can't really help you here, never tried to use Shell to activate OE
> (or Outlook) and send an email.
> I have always use the default email manger on the system.
>
> Have you had a look at
> http://word.mvps.org/faqs/interdev/sendmail.htm
> It may provide some answers or an alternative.
>
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
date: Fri, 14 Apr 2006 23:41:06 -0400
author: John Ciccone
|
|