totalnovice2
Registered User.
- Local time
- Today, 04:09
- Joined
- May 21, 2013
- Messages
- 36
Hi.
I currently have a working model which opens up a word document template, fills the bookmarks with info from access, saves the file as a preset name and then send the document on Outlook.
What I would like to do is save the document as a variable, preferably as something like " Climbing Request for site (and then to lift the site name from Access page and insert here) "
The location of the site name on access is...
currently I save the document using the below code...
Any help would be really appreciated as this is the last step before "launching" my database automation.
Many thanks.
I currently have a working model which opens up a word document template, fills the bookmarks with info from access, saves the file as a preset name and then send the document on Outlook.
What I would like to do is save the document as a variable, preferably as something like " Climbing Request for site (and then to lift the site name from Access page and insert here) "
The location of the site name on access is...
Code:
objWord.Selection.Text = Forms![Front Page]![Site 2 Owner]currently I save the document using the below code...
Code:
objWord.ActiveDocument.SaveAs2 FileName:="C:\Users\me\desktop\From Colin\o2test.docx"Any help would be really appreciated as this is the last step before "launching" my database automation.
Many thanks.
Last edited:
