Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data with options
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data with options
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 "Francisco" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data with options
Hi Francisco,
To see how to do this kind of mailmerge, check out my tutorial at: http://www.wopr.com/cgi-bin/w3t/show...?Number=731107 -- Cheers macropod [MVP - Microsoft Word] "Francisco" wrote in message ... 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data with options
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! "macropod" wrote: Hi Francisco, To see how to do this kind of mailmerge, check out my tutorial at: http://www.wopr.com/cgi-bin/w3t/show...?Number=731107 -- Cheers macropod [MVP - Microsoft Word] "Francisco" wrote in message ... 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data with options
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] "Francisco" wrote in message ... 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! "macropod" wrote: Hi Francisco, To see how to do this kind of mailmerge, check out my tutorial at: http://www.wopr.com/cgi-bin/w3t/show...?Number=731107 -- Cheers macropod [MVP - Microsoft Word] "Francisco" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How do I move data Colums within the data source of a mail merge | Microsoft Word Help | |||
data in mail merge letter being cut off - data source field size? | Mailmerge | |||
Merged data that is present in data source is missing in merge | Mailmerge |