mdemarte
Computer Wizard
- Local time
- Today, 23:14
- Joined
- May 8, 2001
- Messages
- 138
I have a database of vendors, each vendor could supply more than one product. I need to be able to allow the user to find the data they want (say, all coffee vendors), and then export the names and addresses of the vendors so the user can do a mail merge.
I know that I can create a form with the data, but the body of the letter will change and we don't want to give the user the ability to change the forms.
With a macro, I have been able to export the data, even just the names and addresses, but how do restrict it to just the found set of records?
If it helps, it looks like I will put the data into an Excel spreadsheet (some of the fields are blank, so putting it directly into MS Word might cause problems with the merge).
I tried looking at OutputTo and TransferSpreadsheet, but did not see the parameter to use just the data that is found.
Thanks.
I know that I can create a form with the data, but the body of the letter will change and we don't want to give the user the ability to change the forms.
With a macro, I have been able to export the data, even just the names and addresses, but how do restrict it to just the found set of records?
If it helps, it looks like I will put the data into an Excel spreadsheet (some of the fields are blank, so putting it directly into MS Word might cause problems with the merge).
I tried looking at OutputTo and TransferSpreadsheet, but did not see the parameter to use just the data that is found.
Thanks.
