Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Michael Hoeben Michael Hoeben is offline
external usenet poster
 
Posts: 1
Default Creating a Customer Statement by merging Excel with Word

I have a basic excel database containing names, addresses, postcode as well
as a list of items purchased; so the field names (column titles) are;
Name Address Postcode Itemcode ItemDescrip Qty Price-Each Total

I wish to create a mail merge document in Word which will find each unique
customer name record and then list the sales items or invoices below - almost
like a statement.

Smith, 8 Up St, London, SW1, 25488, Paint 5l, 2, 6.00, 12.00
Smith, 8 Up St, London, SW1, 25488, Paint 5l, 2, 6.00, 12.00
Jones, 1 Down St, Dover, DP2, 12345, Shoes, 1, 15.00, 15.00

I have been able to create something basic, but if there is more than one
itemcode per customer, then I don't know how to have each record printed,
before it goes to the next unique customer name.
I am sure I need some kind of If statement to say "If there is more than one
row with the same unique name or number, then include them in the table.
Otherwise, goto the next customer record.

I would appreciate any advice that anyone can offer.

Thanks
Michael


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Creating a Customer Statement by merging Excel with Word

If you have something like Access, it's probably better to use Access
reporting for this kind of task as it's designed for it. Otherwise, see e.g.

http://support.microsoft.com/kb/211303

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Michael Hoeben" wrote in message
...
I have a basic excel database containing names, addresses, postcode as well
as a list of items purchased; so the field names (column titles) are;
Name Address Postcode Itemcode ItemDescrip Qty Price-Each Total

I wish to create a mail merge document in Word which will find each unique
customer name record and then list the sales items or invoices below -
almost
like a statement.

Smith, 8 Up St, London, SW1, 25488, Paint 5l, 2, 6.00, 12.00
Smith, 8 Up St, London, SW1, 25488, Paint 5l, 2, 6.00, 12.00
Jones, 1 Down St, Dover, DP2, 12345, Shoes, 1, 15.00, 15.00

I have been able to create something basic, but if there is more than one
itemcode per customer, then I don't know how to have each record printed,
before it goes to the next unique customer name.
I am sure I need some kind of If statement to say "If there is more than
one
row with the same unique name or number, then include them in the table.
Otherwise, goto the next customer record.

I would appreciate any advice that anyone can offer.

Thanks
Michael



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
Excel and Word - mult lines on info on excel for one customer Kenya Mailmerge 3 June 13th 07 06:33 PM
Merging from Excel to Word. Tree Branch[_2_] Microsoft Word Help 2 May 22nd 07 05:32 AM
Creating nametags using Word Template and merging Excel list. vik Microsoft Word Help 0 October 14th 05 10:00 PM
Merging excel with Word $ and % format is lost when merging Mailmerge 1 March 31st 05 05:04 PM
creating an invitation for a customer appreciation event? rhino Microsoft Word Help 1 February 8th 05 10:55 PM


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