[codwilco]

I have an excel spreadsheet something like the following:

1 Person1 25.00 Address1
1 Person1 49.00 Address1
2 Person2 120 Address2
3 Person3 50 Address3
3 Person3 48 Address3
3 Person3 499 Address3

I need one letter for each person with the amounts listed multiple times on
the document. So, I need a record change within the document for each value
and a new document for each record number change.

I cannot figure out how to do this. Any suggestions would be appreciated.

Dave

[codwilco]

Nevermind. On further research, I am going to just dump the data into Access
and take care of it there! Seems like too much trouble.

"codwilco" wrote:

I have an excel spreadsheet something like the following:

1 Person1 25.00 Address1
1 Person1 49.00 Address1
2 Person2 120 Address2
3 Person3 50 Address3
3 Person3 48 Address3
3 Person3 499 Address3

I need one letter for each person with the amounts listed multiple times on
the document. So, I need a record change within the document for each value
and a new document for each record number change.

I cannot figure out how to do this. Any suggestions would be appreciated.

Dave

[Doug Robbins - Word MVP]

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.



--
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, originally posted via msnews.microsoft.com
"codwilco" wrote in message
...
I have an excel spreadsheet something like the following:

1 Person1 25.00 Address1
1 Person1 49.00 Address1
2 Person2 120 Address2
3 Person3 50 Address3
3 Person3 48 Address3
3 Person3 499 Address3

I need one letter for each person with the amounts listed multiple times
on
the document. So, I need a record change within the document for each
value
and a new document for each record number change.

I cannot figure out how to do this. Any suggestions would be appreciated.

Dave

[Doug Robbins - Word MVP]

I agree. Access reporting capability is extremely powerful.

--
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, originally posted via msnews.microsoft.com
"codwilco" wrote in message
...
Nevermind. On further research, I am going to just dump the data into
Access
and take care of it there! Seems like too much trouble.

"codwilco" wrote:

I have an excel spreadsheet something like the following:

1 Person1 25.00 Address1
1 Person1 49.00 Address1
2 Person2 120 Address2
3 Person3 50 Address3
3 Person3 48 Address3
3 Person3 499 Address3

I need one letter for each person with the amounts listed multiple times
on
the document. So, I need a record change within the document for each
value
and a new document for each record number change.

I cannot figure out how to do this. Any suggestions would be
appreciated.

Dave