Rocky Smolin
rockysmolin at bchacc.com
Mon Oct 11 11:18:39 CDT 2010
Dear List:
I automated some customer response letter in my customer tracking system -
opens a word , inserts the contents into the body of an email, closes the
doc. When the doc closes, though, I get a notice that normal.doc has been
altered do I want to save it, etc. PITA because of course, I have to
respond to the prompts.
What am I doing wrong? The code's pretty minimal:
Private Sub MakeMessage(argDocument As String, argSubject As String)
Dim objWord As Object
Dim objWordDoc As Word.Document
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment
' Get the body text
Set objWord = CreateObject("Word.Application")
objWord.Documents.Open (argDocument)
objWord.Selection.WholeStory
strBody = objWord.Selection
'MsgBox strBody
objWord.Documents.Close
objWord.Quit
Set objWord = Nothing
(code here to send email - working well
End Sub
MMTIA,
Rocky Smolin
Beach Access Software
858-259-4334
Skype: rocky.smolin
www.e-z-mrp.com <http://www.e-z-mrp.com/>
www.bchacc.com <http://www.bchacc.com/>