Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] Zhuklinets@gmail.com is offline
external usenet poster
 
Posts: 2
Default Meging data from SQL Source - something like catalog, but not

Hello. I need to merge some data from MS SQL with word template.
There are many lines - some fields are unique, some not. I.e.
Table:
ID FirstName LastName Number Language
1 Mary Ann 1 Lang1
1 Mary Ann 1 Lang2
1 Mary Ann 1 Lang3
2 Peter Stas 1 Lang1
2 Peter Stas 1 Lang2
3 Bob Marley 1 Lang1

Document must be like:

Employee Mary Ann with number 1 knows
there is a table
--------------
Lang1 |
-------------
Lang2 |
-------------
Lang3 |
---------

And other docs with other people.

I've found article http://support.microsoft.com/kb/211303, but I can't
even make work correctly their example -
in doc was page breaks, city appears twice at first iteration... And I
can't insert here my code from document also.

Could anyone helps to solve that problem with complex merging?
 
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
Meging to a table with section breaks bristol Mailmerge 1 June 13th 07 12:11 PM
How to link a different Mailmerge header source and data source? Eleni_Malli Mailmerge 1 May 3rd 06 02:08 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM
Merged data that is present in data source is missing in merge mbd_newjersey Mailmerge 1 December 17th 04 10:52 AM


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

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

About Us

"It's about Microsoft Word"