IT's A Challenge (for Tough Brains)

[manjeetsingh]

i am writing a mail merge program.problem,is
i want to sort the datasource,based on a field like
(CompanyName) and then there should be a option where
i could make a merged file containing companynames in a sorted order and between some range.
like companyname starting with 'A' to Companyname starting
with 'J' , CompanyName starting with 'K' to companyName
starting with 'Z' and so on.
Please help.

this is the datasource code i am using
--
objWord.MailMerge.OpenDataSource _
Name:="" & strDataSource & "", _
LinkToSource:=True, _
Connection:="TABLE " & strTableName & "", _
SQLStatement:="Select * from [" & strTableName & "] "

 

[petermeachem]

Not that difficult. You need to add a WHERE clause that's all. Look up WHERE in help related to sql statements. Peter Meachem
peter@accuflight.com

 

[petermeachem]

Not that difficult. You need to add a WHERE clause that's all. Look up WHERE in help related to sql statements. Peter Meachem
peter@accuflight.com

 

[manjeetsingh]

dear peter ,thanks alot.
i had already tested that.
But both OrderBy and Where clauses are not working in the
SQLStatement specified in the OpenDataSource statement.