Hi all
Have an MS Access database which generates a table based upon a qry, the table then used as datasource for mailmerge action in a word document. Until recently this worked fine but now, as end-user numbers increase, I want to move to a different mode.
Using VBA I've managed to export the table as a xl doc to the users personal temp directory, using environ$(TEMP). My problem now is that I can't use environment variables in the datasource path.
Can anyone advise how to actually see and edit the merge header in word 2000 (just like in the good old days of word 2.1). All I can manage is that damned mail-merge helper window which will only allow constant paths to be entered, not something like %TEMP%\TblMrgDoc.xls
Show me that damned mergeheader field!
Thanks
xentaur
Have an MS Access database which generates a table based upon a qry, the table then used as datasource for mailmerge action in a word document. Until recently this worked fine but now, as end-user numbers increase, I want to move to a different mode.
Using VBA I've managed to export the table as a xl doc to the users personal temp directory, using environ$(TEMP). My problem now is that I can't use environment variables in the datasource path.
Can anyone advise how to actually see and edit the merge header in word 2000 (just like in the good old days of word 2.1). All I can manage is that damned mail-merge helper window which will only allow constant paths to be entered, not something like %TEMP%\TblMrgDoc.xls
Show me that damned mergeheader field!
Thanks
xentaur
