Unanswered: Export current record to Word or Excel
My objective is to get the current record selected to export to a Word mail merge file that I have already set up. I've looked in Help and the only thing remotely close was to go to File, Export... I don't want to have to export it manually. Macros don't seem to be working either.
The record is in a temp table called Label (defined by a make-table query of the current record). Our company prints out certain pieces of information for the file folder label. These labels are set up for the Avery, 2 across kind. Also, the data needs to be played with once it gets to the word template (it has to be formatted because the size of the address changes and throws everything off.
Right, now I think that I understand, you are only using an Access table as the data source.
Why don't you do the merge from word using the access table, if it is a temp table and the data changes you could link to the table and it would get the current data each time you ran the merge.
Sorry to harp, but have a look at doing these labels in Access you will find that you have better control than word. Access lists about 150 different type of Avery Labels by their number........ have a look
Using access would also solve you soring problem, having said that you can also define the sort in ms Word mege.