Merge data with options

[Francisco]

I have a word document (Packing slip) that I want to populate with
information from an excel sheet. In the excel sheet I have many rows that
contain order, customer, and item information. Each row is for different item
number. If a customer has purchased more tan one item (three, for example)
there will be three
rows for that customer and each row will contain an item information along
with the
order and customer information.
How do I make MS Word to merge and create one page with all the items for
one customer?
I cannot change the format of the excel file since I use the same file for
other applications.
Please help!
Francisco

 

[Doug Robbins - Word MVP]

See

http://cornell.veplan.net/article.aspx?&a=3815


--
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

 

[macropod]

Hi Francisco,

To see how to do this kind of mailmerge, check out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

 

[Francisco]

Thank you Paul.
I visited the link you mentioned and I was able to download the zip file.
I can see and understand how this works but I cannpt see the formulas you
created.
You know, the IF statements where they check and validate the data.
Where do you actually go to insert the formula? and what is the formula?

I noticed the flag in your link. Are you actually in Chile?

My Wife is from there!

Hi Francisco,

To see how to do this kind of mailmerge, check out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]

I have a word document (Packing slip) that I want to populate with
information from an excel sheet. In the excel sheet I have many rows that
contain order, customer, and item information. Each row is for different item
number. If a customer has purchased more tan one item (three, for example)
there will be three
rows for that customer and each row will contain an item information along
with the
order and customer information.
How do I make MS Word to merge and create one page with all the items for
one customer?
I cannot change the format of the excel file since I use the same file for
other applications.
Please help!
Francisco

 

[macropod]

Hi Francisco,

See 'Viewing The Fields' and 'How the Categorisation Mailmerge Process Works' in the tutorial's Introduction.

As for the flag, that changes daily - I believe according to each country's national day. I've been to Chile a number of times, but
I don't live there - I'm from Australia.

--
Cheers
macropod
[MVP - Microsoft Word]

Thank you Paul.
I visited the link you mentioned and I was able to download the zip file.
I can see and understand how this works but I cannpt see the formulas you
created.
You know, the IF statements where they check and validate the data.
Where do you actually go to insert the formula? and what is the formula?

I noticed the flag in your link. Are you actually in Chile?

My Wife is from there!

Hi Francisco,

To see how to do this kind of mailmerge, check out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]

I have a word document (Packing slip) that I want to populate with
information from an excel sheet. In the excel sheet I have many rows that
contain order, customer, and item information. Each row is for different item
number. If a customer has purchased more tan one item (three, for example)
there will be three
rows for that customer and each row will contain an item information along
with the
order and customer information.
How do I make MS Word to merge and create one page with all the items for
one customer?
I cannot change the format of the excel file since I use the same file for
other applications.
Please help!
Francisco