Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

Is there a way to run merge records from Excel which groups certain
records together.
I have a report which is exported from a finance system and I want to
have a generic template which I can merge outstanding invoices.

One site in this report may have 10 outstanding invoices but currently
I've been unable to figure out how to "group" the records together.

A sample:

Line No. | Invoice No. | Date | Description | Cost Centre | Invoice Amt
| Payment Amt | Balance | Attention | Email
1 | 100 | 1/01/01 | John Doe | 001030 | 345 | 0 | 345 | Jane Doe |
ess

....and so forth.

The current report is 207 lines long and one person could have 2
records and some could have 30 records.

Is there a way to group records via Name or Email address for merge?
What I want to achieve is each outstanding invoice record for Jane Doe
is listed in a table in word and I can't remember how I did (it's been
a few years).

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge from Excel data source

This is not something that Word's merge is designed to do, and to force it
to do so is complex - see How to use mail merge to create a list sorted by
category in Word 2002 - http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Santa-D wrote:
Is there a way to run merge records from Excel which groups certain
records together.
I have a report which is exported from a finance system and I want to
have a generic template which I can merge outstanding invoices.

One site in this report may have 10 outstanding invoices but currently
I've been unable to figure out how to "group" the records together.

A sample:

Line No. | Invoice No. | Date | Description | Cost Centre | Invoice
Amt
Payment Amt | Balance | Attention | Email

1 | 100 | 1/01/01 | John Doe | 001030 | 345 | 0 | 345 | Jane Doe |
ess

...and so forth.

The current report is 207 lines long and one person could have 2
records and some could have 30 records.

Is there a way to group records via Name or Email address for merge?
What I want to achieve is each outstanding invoice record for Jane Doe
is listed in a table in word and I can't remember how I did (it's been
a few years).



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

I had been trying that out yesterday and the results came out different
than what's displayed on their sample.
The MS example (which is what I used to see if I can get it to work)
stated this:

The fields laid out in this example produce a sorted list as follows:
Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

Houston

Johnson $8,000
Kelly $9,000
Pak $0

Except, I had every line on a seperate page (and I didn't use the
pagebreak option)
I'm using Word 2003.

It's not as if we could use Word as a front end and run a query on the
excel data?

While KEY1 = PRIMARY.KEY then
return data that relates to PRIMARY.KEY in table
End While



Graham Mayor wrote:
This is not something that Word's merge is designed to do, and to force it
to do so is complex - see How to use mail merge to create a list sorted by
category in Word 2002 - http://support.microsoft.com/?kbid=294686


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

I came across another site that explains it in simple terms.

http://cornell.veplan.net/article.aspx?&a=3815

I don't think these can be emailed.

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

I've also discovered that I can not put the fields a table otherwise it
won't expand the list. It will be restricted to the one row or as many
rows as included in the table.



  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge from Excel data source

Dis you set the document type to Directory?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Santa-D wrote:
I had been trying that out yesterday and the results came out
different than what's displayed on their sample.
The MS example (which is what I used to see if I can get it to work)
stated this:

The fields laid out in this example produce a sorted list as follows:
Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

Houston

Johnson $8,000
Kelly $9,000
Pak $0

Except, I had every line on a seperate page (and I didn't use the
pagebreak option)
I'm using Word 2003.

It's not as if we could use Word as a front end and run a query on the
excel data?

While KEY1 = PRIMARY.KEY then
return data that relates to PRIMARY.KEY in table
End While



Graham Mayor wrote:
This is not something that Word's merge is designed to do, and to
force it to do so is complex - see How to use mail merge to create a
list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686



  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

Did you set the document type to Directory?

Certainly did and it worked as hoped but as soon as I tried to include
the records in a table, it didn't work.
I couldn't have records split into rows.

If I emailed the documents across would that give you a better
understanding?

  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

I found something a bit different, doesn't use word but uses excel and
it does the job.
It's rather interesting how it works and it does the job.

http://ukww.net/patools/excel/am.htm

  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Santa-D Santa-D is offline
external usenet poster
 
Posts: 8
Default Mail Merge from Excel data source

I also came across this.

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

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
Mail Merge and Excel data to print Labels G.Wee Mailmerge 1 August 22nd 06 12:46 PM
Word 2003 Mail Merge Problem when E-Mailing Data Source Karen Townsend Mailmerge 3 June 20th 06 08:21 AM
Word 2002 cannot find its Excel data source for mail merge harryedwards Mailmerge 5 November 23rd 05 11:09 AM
mail merge using excel file as data source Laurina Mailmerge 1 January 31st 05 03:10 PM
Mail merge data source problem campwes Mailmerge 1 January 25th 05 07:16 PM


All times are GMT +1. The time now is 06:46 AM.

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"