Hey,
I'm attempting to design a macro that will mail merge based on the row selected. I have the part where it loops through the selected row and its other details, but am struggling to create a connection string which filters it down based on this. I have tried the following:
The part that is giving me an error is the WHERE part of the statement. UPN is the column header and strUPN contains the specific UPN I'm looking for (unique pupil number - for a school). Have tried it with and without quotes etc...Please Login or Register to view this content.
What is the correct SQL syntax to use when dealing with VBA/Excel sheets?
Thanks in advance,
Paul
Bookmarks