View Single Post
  #1 (permalink)  
Old January 30th, 2007, 04:50 PM
donrafeal donrafeal is offline
Authorized User
 
Join Date: Apr 2004
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to copy text in a word file on the clipboard

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

Reply With Quote