Mail Merge Function

I require an ASP function that will perform the following: 1. Receive an SQL query that will be used to generate a recordset. 2. Perform a mail merge from the query and print or email the resulting letters. 3. Save a copy of each letter printed or emailed to the client's directory. 4. Receive variables to be used for the email (From, CC, BCC and MsgText) 5. Receive a variable to over-ride the auto email function. The function will be: **GenerateLetter(strSQL, strTemplate, bolPrint, bolPrinter, strFrom, strCC, strBCC, strSubject, strMsgText)** **strSQL** = Mandatory variable. Contains an SQL statement as a string, that will generate the recordset. The recordset could have either one or multiple records. Each record requires a letter to be produced. One call the the functions may produce multiple emails to be sent and letters to be printed. **strTemplate** = Mandatory variable. Contains a String with the name of the template to use for the mail merge. The letter templates for the mail merge will be stored in a directory one level down from the scripts. Eg: /WordTemplates/[login to view URL] **bolPrint** = Mandatory variable. Contains a Boolean value to determine if the letter is be ONLY printed (True) or determine the function (False), that is print or email from the recordset. If bolPrint is False then to determine the function is via the field “Communicate?? in the recordset. Letter = Print the letter. Email = Produce and email the letter. Emailed letters are to be attached to the email that is produced. All letters are to be saved. **bolPrinter** = Mandatory variable. Contains a Boolean value to determine which printer to use. True = Servers default printer. False = Workstations default printer. Saving the letters generated. The client is identified via the client ID in the generated recordset. The Client ID field is “ClientID??. **See the attached file for full details.**- Update 23 Jan 03. Read attachment ## Deliverables 1) Complete and fully-functional working function. Complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. If necessary. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Windows 2000 Server MS Access 2002 ## Deadline information **This function is required as soon as possible** I will only accept bids from those who can garantee that the work will be completed as specified in the time required.