VB^ + MS Word Mail Merge

[rennis]

Has anyone ever come across the following error when trying to complete a mail merge in ms word, using data from vb6?

"String is Longer then 255 characters"

It occurs on the .opendatasource line with the Select statement.
Select * from table where primary_key in ("& the_primary_key_var &")

In this instance the_primary_key_var represents all primary keys selected separated by a comma (1,2,3,4,5,6) etc.

Any help is appreciated

 

[simonkue]

rennis,

Not sure if I'm reading this right, but is that the exact SQL statement?

Select * from table where primary_key in ("& the_primary_key_var &")
If you are putting the sql into a string I would expect to see:
sSQL="Select * from table where primary_key in (" & the_primary_key_var & ")"

HTH