Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SEAN DI''''ANNO SEAN DI''''ANNO is offline
external usenet poster
 
Posts: 1
Default How to Group Orders By Customer Number In Word 2000

Hi ladies and gentleman. In theory I though this would be easy but I am
really struggling. I have an Excel file simlar in format to;

Supplier No Supplier Name Order No
S1 Seton 1
S1 Seton 2
s2 Brady 3

I am trying to do a mail merge in word which for the header has the Supplier
No and Name and then lists all of the order which belong to that Supplier. I
know this would be easy in Access but I want to learn some more about Word.


Eg

1st page Supplier S1 - Seton
Your orders are;
1
2

Next Page etc. If this is possibe, I would need to know how to force a new
page if for example the same supplier has hundreds of orders.


Can any one please be kind enough to show me how this can be done if at all.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How to Group Orders By Customer Number In Word 2000

Word does not really have the ability to do this. You would be better off
to stick to Access, but, see the "Group Multiple items for a single
condition" item on fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


or at:

http://www.knowhow.com/Guides/Compou...poundMerge.htm


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

"SEAN DI''''ANNO" wrote in message
...
Hi ladies and gentleman. In theory I though this would be easy but I am
really struggling. I have an Excel file simlar in format to;

Supplier No Supplier Name Order No
S1 Seton 1
S1 Seton 2
s2 Brady 3

I am trying to do a mail merge in word which for the header has the
Supplier
No and Name and then lists all of the order which belong to that Supplier.
I
know this would be easy in Access but I want to learn some more about
Word.


Eg

1st page Supplier S1 - Seton
Your orders are;
1
2

Next Page etc. If this is possibe, I would need to know how to force a
new
page if for example the same supplier has hundreds of orders.


Can any one please be kind enough to show me how this can be done if at
all.



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
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
Reveal codes in a word document FUN101 Microsoft Word Help 4 May 16th 23 08:47 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM


All times are GMT +1. The time now is 10:15 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"