D
daymaker
Let's say I have the following excel file that has NAME (custome
account name), ORDER # and order DATE. (I can convert this to an Acces
file if better for my application...)
[image
http://i67.photobucket.com/albums/h292/jkilday4/DummyexceltableforumquestionB40212-1.jpg]
As you can see, some account names have more than one order number an
respective order date. I am wanting to merge all orders for eac
account to a Word template in a way that compiles a table list of al
orders and order dates, rather than having a different letter for eac
account/order #. So my merged letter would look like this:
[image
http://i67.photobucket.com/albums/h292/jkilday4/Dummywordforumquestion0212.jpg]
If this is not possible in Word, I am wondering if I can edit the dat
(excel or access) file so that for each account that has more than on
order, the order #'s and dates are listed out successively in th
account name's row (and duplicate account names/rows are then deleted)
like this:
[image
http://i67.photobucket.com/albums/h292/jkilday4/Dummyexceltableforumquestionafter0212-2.jpg]
Hopefully then I would be able to do the merge to Word successfully.
Thanks for any help you can offer!
Joh
account name), ORDER # and order DATE. (I can convert this to an Acces
file if better for my application...)
[image
http://i67.photobucket.com/albums/h292/jkilday4/DummyexceltableforumquestionB40212-1.jpg]
As you can see, some account names have more than one order number an
respective order date. I am wanting to merge all orders for eac
account to a Word template in a way that compiles a table list of al
orders and order dates, rather than having a different letter for eac
account/order #. So my merged letter would look like this:
[image
http://i67.photobucket.com/albums/h292/jkilday4/Dummywordforumquestion0212.jpg]
If this is not possible in Word, I am wondering if I can edit the dat
(excel or access) file so that for each account that has more than on
order, the order #'s and dates are listed out successively in th
account name's row (and duplicate account names/rows are then deleted)
like this:
[image
http://i67.photobucket.com/albums/h292/jkilday4/Dummyexceltableforumquestionafter0212-2.jpg]
Hopefully then I would be able to do the merge to Word successfully.
Thanks for any help you can offer!
Joh