Im not very experienced in programming with Access, and I have a question about the export delimiter. I have two tables:

Course_List:
Workshop Name
Workshop Location
Workshop Number
Workshop Status
Date
Max Size

Enrollment:
Name
SSN
Department
Address
Phone
Email
Workshop Name
Status

I made a query called Email, that gives the user a dialog box and allows them to enter a workshop number. It then retrieves the email address of each person enrolled in that particular workshop. I have a form created with a button that runs this query using the TransferText action, then outputs it to a textfile named Email located on my C drive. I need the output in this format though: [email protected]; [email protected]; etc. etc. I cannot figure this out. If someone could help me, I would really appreciate it. I already tried using the Export Text Wizard and creating delimiters through that, but it's not working out too well.

This is the code I currently have in the button procedure:
Private Sub buttonEmail_Click()
On Error GoTo Err_buttonEmail_Click

    Dim stDocName As String

    stDocName = "C:\Email.txt"
    DoCmd.TransferText acExportDelim, , "Email", stDocName, True

Exit_buttonEmail_Click:
    Exit Sub

Err_buttonEmail_Click:
    MsgBox "The following error was encountered:" & Chr(13) & Err.Number & ": " & Err.Description, vbOKOnly, "Error"
    Exit Sub

End Sub

Thanks