GoldMine 6.5 sort order 1

[ndole]

Hi!
Since the update from GoldMine 6.0 to 6.5-SQL, it is no more possible to print merged letters and labels in the same order (alphabetical or any other order!). Mailing actions have become a nightmare.

Is there a smart soul out there who could help me?
Thanks
Ndole

 

[captrick]

I'm no expert, but I would think you could build your filter to merge by using a SQL Querey that has an Order By or Group By statement to put the records in a specific order..

 

[richardy]

Hi,

How are you printing the letters?

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com.au

 

[ndole]

First thanks to the two of you guys for your post.
> I'm afraid I'm no SQL expert. But

> After having created a filter I do print
1) my letters just the way I used to with GM 6.0. i.e. Contact > Write > Mail Merge > Template > Recipient and print
2) my labels : Reports > Labels and Envelopes : here by clicking the button 'Reports Center' I can do something with the sort order. As I could not find out HOW the letters are sorted, I check now 'primary' for SORT LEVELS, 'contact1' for SORT DATABASE ans 'account' for FIELD NAME.

As I said, I could not find out the sort criteria for the letters (by city, company, phone etc.) that's why I check 'account' for the labels. But it does not match at all the order of the letter as well.

 

[richardy]

Are you using a filter? In which case alter the optimisation in it to set the sort order.