It looks like you're new here. If you want to get involved, click one of these buttons!
I have a macro which execute several mail merges. I have this instruction to select the options I need for the first mail merge:
ActiveDocument.MailMerge.DataSource.QueryString = _
"SELECT * FROM `Master` WHERE ((Surname >= 'A') AND _(Surname < 'B')) ORDER BY Surname, Firstname" & ""
I need to replace the 'A' and 'B' for variables because I have to do a mail merge for each character of the alphabet. I thought I could have this:
Dim Alphabet As Variant
Alphabet = Array("A", "B", "C", ......, "Z")
I tried to replace the 'A' by Alphabet(0) and the 'B' by Alphabet(1) but it doesn't work.
Can somebody please help me? Thank you!
Logistec Stevedoring Inc.