Access 2003: Exporting query to a word doc
Posted on 2012-03-22
Have a query that contains:
SELECT x.Asterisk & " " & x.Calc_DiplomaName & " " & x.Specialty AS Info
ORDER BY x.[Last Name], x.[First Name];
It create a 1 column field (that concantentates several fields)
Would like to export to word doc.
(the way i do it manually is:
run the query, ctl+a, ctl+c, open word, ctl+v
word has a little clipboard, from there i select text only
then ctl+a, and change the font style and size)
Want to do the above steps from Access using vba.
I learned how to open a word doc, that has properties placed in the doc like in a letter.
However, this is just dumping all the data instead of into excel using the copyrecordset command instead into word.
Does anybody have vba logic to do this?
Below pasted code that i used for a word doc with properties. Maybe you can help me
modify this code.
(Anybody know where i the code window is in the new EE interface?)
tx in advance for your help and ideas, sandra