#1   Report Post  
Posted to microsoft.public.excel.misc
Mac Kearney
 
Posts: n/a
Default Mail merging

Hi,

I have got a mail merge doc set up in word, but I would like it to merge
every record in the excel file into the doc. I can't find the option to do
that. All it is doing is merging the first record into the doc.

Can someone tell me where you set it up to import all the records in the
data source (.xsl file) into the word doc?

Thanks!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheila D
 
Posts: n/a
Default Mail merging

Try giving the block you want to use a Range name then choose that range to
connect to - you should have the 1st row with headings (field names) and no
blank rows/columns for it work most effectively
HTH - Sheila

"Mac Kearney" wrote:

Hi,

I have got a mail merge doc set up in word, but I would like it to merge
every record in the excel file into the doc. I can't find the option to do
that. All it is doing is merging the first record into the doc.

Can someone tell me where you set it up to import all the records in the
data source (.xsl file) into the word doc?

Thanks!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merging when you only have 2 excel spreadsheets Kelly Edwards Excel Discussion (Misc queries) 3 April 7th 06 11:56 PM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 06:32 PM
Dates keep changing to US format when mail merging SEAN DI''''ANNO Excel Discussion (Misc queries) 0 October 13th 05 04:30 PM
Hold format from excel to data source for mail merging Frank3 Excel Worksheet Functions 2 October 5th 05 05:55 PM
Mail Merging mrbroad Excel Discussion (Misc queries) 1 September 17th 05 09:01 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"