Select all values

[#1]

Hello QV Experts

ActiveDocument.Fields("SheetID").GetPossibleValues will not fetch all values. But I want to include everything including duplicates. Please suggest.

Thanks & Regards
 

[#2]

Hi

try this

valuescommaseperated= ActiveDocument.Evaluate("Concat(distinct([Field Name]),',')")

valuesarray= Split(valuescommaseperated,",")

then use foreach loop as

for each value in valuesarray

     msgbox value

next

[#3]

do not use distinct if you want duplicates also.

[#4]

Hi Swapnil,

Below code fetches me only one value, whereas table contains 46 rows all are numbers.

valuescommaseperated= ActiveDocument.Evaluate("Concat([Indx],',')")

valuesarray= Split(valuescommaseperated,",")

msgbox(valuescommaseperated)
for each value in valuesarray

   msgbox value

next