mail merge (attaching a text from word doc to body of email)

[AT76]

In my Access app I executing a mail merge. The mail merge works fine but I would likle to attach contents of a word doc to the body of the email. Is this possible? I know you can attach a string to the body of the email, but how do you specify a specidic location of the word document and then attach its contents to the body of the email?

Thank you for any help provided!

 

[rjoubert]

Check out the help file for the Docmd.SendObject method.

 

[rjoubert]

Sorry...looks like that won't work for you. Docmd.Sendobject only works with objects within your Access database. It won't work for a Word doc.

 

[rjoubert]

Are you using Outlook for your email? If so, this might help you...

http://www.jephens.com/howtoemail.asp

 

[AT76]

Yes, I'm using outlook. I will read! Thanks!

 

[AT76]

rjoubert, I tried the following code:

    Dim fso As FileSystemObject
    Dim MyBody As TextStream
    Dim MyBodyText As String
    Dim BodyFile As String


    Set fso = New FileSystemObject
    BodyFile = "W:\MATERIAL\SURPLUS\ReturnsNA\body.doc"

   ' Since we got a file, we can open it up.
    Set MyBody = fso.OpenTextFile(BodyFile, ForReading, False, TristateUseDefault)

   ' and read it into a variable.
    MyBodyText = MyBody.ReadAll
    
    objSafeMail.Body = MyBodyText

   ' and close the file.
    MyBody.Close
    objSafeMail.Send

What I got in the body of the email (ÐÏࡱá
) was not what I had in the word doc.

Any ideas as to why? Thanks!