|I have an Access 2003 report that I need to export, to separate files for separate recipients. Currently, I do this by having separate copies of the report saved with individual filters – e.g., [Recipient]=”name 1” – and running a macro using “Output To” to export each file separately.|
What I’d like to do (I think) is to have a single copy of the report with a filter like [Recipient]=[Name], and in a macro swap name1, name2, name3 etc. into [Name], so that it would read something like:
Set [Name] = “name1”;
Set [Name] = “name2”;
But I can’t find a way to change the value of [Name] from within a macro. Any ideas?