![]() |
|
#1
|
|||
|
|||
![]()
Hey guys,
Ive been reading up on how to fix this problem but I just cant seem to sort it out myself *derp* I need to merge a list of multiple people which varies every week into this format. This is the current format Im using, but when I try and merge the datain it just adds the first person on the list over and over, I can never get the other people listed into the mail merge. What am I doing wrong? Hope someone can please help me out, would really appreciate some help. ![]() |
#2
|
||||
|
||||
![]()
After all except the last of your «AmountOwing» fields, you need to insert a «NextRecord» field - from the 'Rules' dropdown. The «NextRecord» field could go in the adjacent cell, for example.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
That didnt work, I did try that.
|
#4
|
||||
|
||||
![]()
It does work. Are you Finishing the merge, or just doing a Preview? A preview won't show the finalised results.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
I am finishing off the merge. Its not even including everyone on that list. Its just listing 1 person.
|
#6
|
||||
|
||||
![]()
Works for me just fine with your data & document - after I fixed all your mis-named mergefields...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
![]() ![]() I am at the point where I am prepared to pay you to fix it ![]() ![]() |
#8
|
|||
|
|||
![]()
what is incorrect? And I can see the nextrecord field after the merge too.
![]() ![]() ![]() ![]() ![]() |
#9
|
||||
|
||||
![]()
Do you mean what, apart from the fact you've done nothing like what I said in post #2:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
![]()
Im really sorry Paul. I do appreciate your help immensely im sorry to be annoying or frustrating. Im just not understanding which cell it should be in.
|
#11
|
|||
|
|||
![]()
I did it! I am so sorry for annoying you.
Thank you once again. |
#12
|
||||
|
||||
![]()
Presumably your mailmerge main document will now look something like the attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jonpackbosoxfan | Excel | 34 | 09-18-2013 08:38 AM |
![]() |
jmhultin | Outlook | 2 | 08-09-2013 02:01 PM |
![]() |
Nibbles | Excel | 2 | 04-16-2013 07:59 AM |
![]() |
Bob Young | Mail Merge | 5 | 05-18-2012 03:44 PM |
Trying to merge label data from file | ClayShannon | Mail Merge | 0 | 09-16-2009 10:08 PM |