Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lookup records - Highlight subset of records - Edit replace field content

Accepted Solution Solved
PJ
Copper Contributor
Posts: 26
Country: United Kingdom
Accepted Solution

Lookup records - Highlight subset of records - Edit replace field content

I was wondering ...

 

I have 7000 ish records I want to put into groups of about 60.

I have a user defined field "Batch Mailing" which holds a number, this number I search on and do mail merges with.

 

Question

 

What is the easist way to group records into 60s, I can look at the records, find the 60 th record in the dataset and highlight to the top and then just want to edit replace the Batch Mailing list number. However this does ALL the current lookup !

Is there some kind of macro anywhere where I can just do it in code ?

 

Thanks


Accepted Solutions
Solution
Accepted by topic author PJ
‎09-25-2015 03:20 AM
PJ
Copper Contributor
Posts: 26
Country: United Kingdom

Re: Lookup records - Highlight subset of records - Edit replace field content

Thanks Trevor.

Just what I wanted.

View solution in original post


All Replies
Nickel Contributor
Posts: 205
Country: United_Kingdom

Re: Lookup records - Highlight subset of records - Edit replace field content

First, ensure that Tag Mode is selected in the Contact List view. Then, if you select the top to the 60th record and select Lookup Selected - this creates a lookup of the 60 contacts. Now, when you do Edit -> Replace Field for Batch Mailing only those of the current lookup are effected, not all contacts.

 

 

Trevor Lever

UK - ACT Certified Consultant
www.actpartners.co.uk
trevor@actpartners.co.uk
Solution
Accepted by topic author PJ
‎09-25-2015 03:20 AM
PJ
Copper Contributor
Posts: 26
Country: United Kingdom

Re: Lookup records - Highlight subset of records - Edit replace field content

Thanks Trevor.

Just what I wanted.