Mail Merge to a table

[john434]

Hi all,

I am trying to mail merge from an excel spreadsheet into a word doc. The word document is in the form of a table and i need to merge each row of excel with a row in the table. Using the usual mail merge procedure word creates a new page for each row in excel. I'm sure there must be a way round this, but damned if i can find it.

Thanks in advance for your help.

 

[SkipVought]

Hi,

At the end of each row, you must insert an {NEXT} MergeField to get the next record.



Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[dcompto]

Change your your Main Document's document type to Directory or Catalog (depending on what version of Word you are using). By doing so, it will merge a continuous document without page breaks. For example, my Main Document is defined as Directory and has a one-row table:

When merged with my Data Source, containing 4 records, results in:

 

[jgurgen]

how would one do this if they were using an sql database?


«FirstMiddleName» «LastName» : «LoanID»


DETAILS


Fee Details: (2 column table below)
«ItemDescription»«Next Record» «ItemAmount»«Next Record»

 

[SkipVought]

jgurgen,

Please post your question in a NEW THREAD.

Thanx!

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}