View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default word mailmerge field sort

If you want to send me a typical csv file, I can easily produce a macro that
will achieve what you want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jonnyb" wrote in message
...
Doug - thanks again for the response.

A CSV file means the same thing to me as it does to the rest of world, and
you are correct that I don't actually have "cells", but I thought that
using
the "cell" analogy would help explain the task at hand.

Here's an example of what I'm talking about (in csv format):

CSV format:

Order_ID, Customer_Name, Part_Numbers

Sample Data for above format:

"1001", "John Smith", "001" "010" "007"
"1002", "Jill Jones", "031" "002"
"1003", "Bill Williams", "014" "002" "001"

I need to sort the third value (Part_Numbers) so that they appear in
ascending order on my mailmerge document. It would be great if the data
could come to me with either one Part_Number per record (with multiple
records for each order) or with each Part_Number seperated by commas, but
the
client is not willing to change this feed (I guess it's used to feed other
programs so they do not want to change anythng for risk of breaking
something
else that uses the feed).

Any ideas?

I'm actually thinking about just telling the client that they're out of
luck
unless they presort the Part_Numbers during the build of the csv file.

Jon


"Doug Robbins - Word MVP" wrote:

A csv file must mean something different to you than it does to me (and I
think most other people). For starters, it does not contain cells.

A CSV (comma-separated values) file contains the values in a table as a
series of ASCII text lines organized so that each column value is
separated
by a comma from the next column's value and each record starts a new
line.

Provide an example of the data in the file and we can probably tell you
how
to go about it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP