Reply
 
Thread Tools Display Modes
  #1   Report Post  
daymaker daymaker is offline
Junior Member
 
Posts: 1
Default Merging customer file with multiple orders

Let's say I have the following excel file that has NAME (customer account name), ORDER # and order DATE. (I can convert this to an Access file if better for my application...)



As you can see, some account names have more than one order number and respective order date. I am wanting to merge all orders for each account to a Word template in a way that compiles a table list of all orders and order dates, rather than having a different letter for each account/order #. So my merged letter would look like this:



If this is not possible in Word, I am wondering if I can edit the data (excel or access) file so that for each account that has more than one order, the order #'s and dates are listed out successively in the account name's row (and duplicate account names/rows are then deleted), like this:



Hopefully then I would be able to do the merge to Word successfully.
Thanks for any help you can offer!

John
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging data from multiple forms w/multiple fields into one databa Chris C. Mailmerge 4 March 22nd 10 05:53 AM
Merge multiple items [invoices] on one [customer] letter CPA Mailmerge 2 May 28th 09 10:53 PM
Creating a Customer Statement by merging Excel with Word Michael Hoeben Mailmerge 1 September 22nd 07 12:43 AM
Mail Merge with multiple rows for each customer? Mary Beth McNabb Mailmerge 1 April 24th 07 03:39 PM
How to Group Orders By Customer Number In Word 2000 SEAN DI''''ANNO Mailmerge 1 September 27th 06 04:28 AM


All times are GMT +1. The time now is 08:24 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"