Syntax Help Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I pull this up in excel it shows the primary fax number in the first
column but it appears it concantantes the ContactName and AccountName the
second column.

I am trying to get this to write 3 seperate columns.

a.writeLine rs("PrimaryFaxNumber") & ",""" & rs("ContactName") & ",""" &
rs("AccountName") & """"

Any help would be appreciated
 
You may be missing the closing quotes between ContactName nad AccountName:

a.writeLine rs("PrimaryFaxNumber") & ",""" & _
rs("ContactName") & """,""" & rs("AccountName") & """"
 
Back
Top