View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Yookaroo Yookaroo is offline
external usenet poster
 
Posts: 7
Default Need some help importing data

I have 41 products that I need to import into a mailmerge each row has 41
columns and each product is numbered all the 1's in column 1 all the 2's in
column 2 etc

Now I have 0 (Zeros) mixed throughout that mean a person doesnt have that
particular product, how can I import that data in ignoring all the fields
with zeros as a person might get product

1 2 0 4 5 6 7 8 9 0 0 0 0 14 0 0 0 0 19 0 0 22 23 24 25 26 0 28 29 30 31 32 0 0 0 0 0 0 0 0 41

The data is in columns B to AP

After I figure this out I need to ad text before and after these numbers
when imported so that when I import 1 it will look like
"product 01 Pain Relief Topical"

Any help is appreciated