Merging in Word with a SQL query (Stored Procedure) as the data so

L

Lily@Insight

I have set up mail merge documents with the SQL query as the datasource - and
everything is working fine. I have a finicky little question which causes me
grief and if anyone out there can help - I'd be delighted.
When I press the button "Mail Merge Recipients" in the Word document, my
columns represent the fields that are delivered by the query. However - the
ORDER of the columns appears to have NOTHING whatsoever to do with the order
of the fields as created in the SQL query. And manually moving them around -
doesn't help as it doesn't stick (not to mention that it's not a user
friendly window). However - if I click on the button "Insert Merge Field"
that list is in the same order as set up in the query. Go figger! Not the
end of the world - but bugging me. If anyone can enlighten me - I dub thee
"GURU"!
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top