Exporting to Excel for Mailmerging
Posted on 2004-08-23
This is more of a general question. I was wondering if anyone has the time to explain how (using what tags, functions etc) I can create a CF page that:
- creates a new excel file
- exports certain fields of a Users table in a MSSQL database (say into the worksheet (so i can then do a mailmerge into word)
- gives me the option to download the file
- deletes the file after downloading is done
If there is a better way to achieve the mailmerge then feel free to let me know that as well.
Thanks for your time.