I need to do the following automation scenario between ms access and word!
1- Open ms access form based on a record (new record).
2- Insert the fields (doc no#, letter to, letter date, title and picture to), then press a button "Edit Word"
3- Open word template with the data (doc no#, letter to, letter date, title and picture to)-(coming from access form).
4- After employee complete writing word letter text, and when press save(word)
5- Export the data from word document to ms access form (like: doc text … etc)
6- Save an instance of the word document with the name= doc no# in specific folder automatically.
Can I do such thing? Please help