Generating a packing list in Word conditionally from and Excel spreadsheet

Hi Doug,

First off, thanks again for the help. I have done simple mail merge fuctions for years, but hadn't tried the next level (many to one).

I actually had found the 2nd link (

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip) based on your many to one facility in your initial reply. It was extremely helpful. I will take a look at the first link.

Again thanks ,

Barry

The link works OK from here.

Another source of a similar add-in is the following page of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/ManyToOne.htm

Or, for more complex, but more capable methods, see fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge Tutorial" at:

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.

Or if you send me an email, I will send a copy of the MergeTools add-in to you.

In looking at the format this may have sent, it may have cut off a few columns (the ones I referred to in question 3. Here are the next few columns.

Good Morning,

Thanks for the reply. On note: I was unable to get to the SkyDrive link listed (I’ve tried several times, as well as had our IT guy try). I did however find another tutorial  based on your "Many to One facility" comment , and was able to get some fairly good setup done on my directory document.

I have a few questions however.

·         First off, is there another way to get to the link below (I would definitely like to review it)?

·         Is there a way to set conditional page numbers (i.e. as the packing list is building, and it continues to a 2, 3 etc. page, can I set it up to be page [1 of 1],[ 1 of 2, 2 of 2], [1of 3, 2 of 3, 3, of 3], etc.)?

·         If an item only resides on the last line (i.e. carrier, Number_of_Skids, etc.) how do I get it to show on the merged doc? I am only getting it if it’s a one line item. In the example below Name 1 has 3 items and Name 2 & 3 have only 1:

Thanks, and I really do apprecaite your time.

Barry Banning

303.785.5948

Download the MergeTools – 20120609 Add-in that I created from the following page of my Windows Live SkyDrive:

https://skydrive.live.com/?cid=5aedcb43615e886b#cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21111

and use (customizing if necessary) the Many to One facility that it contains.