My Access project includes producing a comma-delimited (CSV) file for later presentation to an email program (LISTSERV Maestro). I'd like to be able to incorporate unicode control characters (e.g., CR/LF, etc) into the file to format the email. How do I do this? Here's the line that produces a record:
For example, how could I insert a CR/LF after sFirstName and a Horizontal Tab (HT) before aCoursePrint(0)?
Code:
Print #1, EmailAddress & "," & sLastName & "," & sFirstName & "," & aCoursePrint(0) & "," & aCoursePrint(1) & "," & aCoursePrint(2) & "," & aCoursePrint(3) & "," & aCoursePrint(4) & "," & aCoursePrint(5)