I need to know how I can use VBA to select a word file and extract the body of that file to place it on the clipboard. The reason for this is I have an MS Access database which I am creating an automated email function with VBA. I want to use VBA to select a word file or word template with autotext and grab all the text within the body of the word file and place it in the body of the email...then with VBA send the email without user involvement. Does anyone have a code example for this? thanks in advanced.

donrafeal

Activedocument.Content.Copy

will copy the contents of the active (current) document.

you can use appropriate object like Documents(1) etc

Cheers
Shasur


http://www.vbadud.blogspot.com

thanks for the help with that. Is there a way to copy the content of a file that is not open?

You can open the word document thru code and then close it

Set oWD = Word.documents.open("c:\sample.doc")

oWD.Content.Copy

' Do the pasting operations

oWD.close SaveChanges:=False

Hope this works out

If you do not want to open Word etc, I think, you can try out reading the file in binary more and transferring the contents

Cheers
Shasur


http://www.vbadud.blogspot.com