Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Phil Smith Phil Smith is offline
external usenet poster
 
Posts: 3
Default Merge drops random records

I am trying to help out my wife with this one. She is running Word
2007, merging from an SQL source, over Citrix, if it makes a difference.

I watched her do this a couple of times, and she seems to be doing
everything correct.

This particular dataset returns 15 records. Basic name and address
stuff. Look at the records, all looks good, no weird data, no problem,
No errors.

However, When you choose to complete the merge and preview or edit the
results, you only get about 8 letters. It drops out records out with no
discernable pattern.

This is with a pre-existing letter, and when she starts over from scratch.

Any Ideas?

  #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 Merge drops random records

Are there any Next Record fields anywhere in the mail merge main
document?

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

"Phil Smith" wrote in message
...
I am trying to help out my wife with this one. She is running Word 2007,
merging from an SQL source, over Citrix, if it makes a difference.

I watched her do this a couple of times, and she seems to be doing
everything correct.

This particular dataset returns 15 records. Basic name and address stuff.
Look at the records, all looks good, no weird data, no problem, No errors.

However, When you choose to complete the merge and preview or edit the
results, you only get about 8 letters. It drops out records out with no
discernable pattern.

This is with a pre-existing letter, and when she starts over from scratch.

Any Ideas?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Phil Smith Phil Smith is offline
external usenet poster
 
Posts: 3
Default Merge drops random records

It is a one page document, with various fields and text in it. I
believe there is a next record at the end after the "Sincerely, Jane
Doe" part.

Is this wrong? Where would you put that particular field?

Thanx



Doug Robbins - Word MVP wrote:
Are there any Next Record fields anywhere in the mail merge main
document?

  #4   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 Merge drops random records

For a Letter type mail merge, no Next Record field is necessary UNLESS
you want to skip records.

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

"Phil Smith" wrote in message
...
It is a one page document, with various fields and text in it. I believe
there is a next record at the end after the "Sincerely, Jane Doe"
part.

Is this wrong? Where would you put that particular field?

Thanx



Doug Robbins - Word MVP wrote:
Are there any Next Record fields anywhere in the mail merge main
document?



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
when I use mail merge the merge drops the '0" of zip code Michbostn Mailmerge 1 June 16th 07 11:10 PM
merge records are using too many decimal spaces when I use records from an Excel Database aspen Mailmerge 1 March 23rd 07 09:12 PM
Combine Mail Merge records when different records have 1 common fi TFFAV Mailmerge 1 December 12th 06 11:56 PM
mail merge drops records at new page lmcwill Mailmerge 3 September 10th 05 06:39 AM
Mail merge drops zip codes and replaces with zero Shana Mailmerge 1 March 7th 05 11:21 PM


All times are GMT +1. The time now is 03:08 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"