A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Merge from Excel Data, multiple lines on same letter



 
 
Thread Tools Display Modes
  #1  
Old June 18th 08, 01:22 AM posted to microsoft.public.word.mailmerge.fields
LuxAeterna
external usenet poster
 
Posts: 2
Default Merge from Excel Data, multiple lines on same letter

I'm trying to do a mail merge of one letter per customer, letting them know
what they were paid for. Problem: Each line designates who was paid and the
amount. Some people were paid more than once. I don't want to create one
letter per payment.

How do I tell the mail merge "If the customer name is the same as the line
before, then put the next payment on a second line on the same letter. If the
customer name isn't the same, move onto the next letter"? Also, can I make it
look like a table?

For example: Joe Smith was paid
$2.00 on 1/2/08
$3.00 on 2/3/08
Ads
  #2  
Old June 18th 08, 03:32 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default Merge from Excel Data, multiple lines on same letter

you are trying to perform a "multiple items per condition (=key
field)" mailmerge which, "out of the box", Word does not really have the
ability to do:

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://cornell.veplan.net/article.aspx?&a=3815


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

"LuxAeterna" wrote in message
...
I'm trying to do a mail merge of one letter per customer, letting them
know
what they were paid for. Problem: Each line designates who was paid and
the
amount. Some people were paid more than once. I don't want to create one
letter per payment.

How do I tell the mail merge "If the customer name is the same as the line
before, then put the next payment on a second line on the same letter. If
the
customer name isn't the same, move onto the next letter"? Also, can I make
it
look like a table?

For example: Joe Smith was paid
$2.00 on 1/2/08
$3.00 on 2/3/08



  #3  
Old June 18th 08, 04:33 AM posted to microsoft.public.word.mailmerge.fields
LuxAeterna
external usenet poster
 
Posts: 2
Default Merge from Excel Data, multiple lines on same letter

Thank you for your reply, Doug.
After posting my question, I looked through the other threads for similar
answers and have referenced the links you listed. I've been trying to follow
both sites, but am not having much luck... I've managed to get a few singular
merge fields to work, but can't get the rest functioning properly.

I neglected to mention that I'm using Office 2007. Are there any resources
(besides articles) you know of that can help me to finish this mail merge?
Consultants, etc?

Thanks again for your time. Much appreciated.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple excel lines on one letter on mail merge. [email protected] Mailmerge 2 October 4th 07 09:23 AM
Merge Excel Data into Word but NOT as a letter format? tough teacher Mailmerge 1 July 26th 06 08:46 PM
How do I stop 0's taking up lines in letter when no data in s/shee Jess Mailmerge 2 September 23rd 05 01:29 AM
Mail Merge letter with Excel Data incorporated gahnzoswife Mailmerge 1 May 18th 05 03:24 AM
Mail merge option with multiple data source records in one letter. E Weij Mailmerge 1 April 18th 05 02:24 PM


All times are GMT +1. The time now is 04:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.