Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MATT
 
Posts: n/a
Default Mail Merge - Header Row

I would like to create a Form Letter, importing data from an Excel Spread
Sheet. On the first few rows of the Excel Spread Sheet is some data not to
be moved, and several rows below the first row is the header row. Of course,
when I go to merge into the document, the fields are not there because it is
reading from Row 1. Is there a way to specify that the header row is Row
"x", thus ignoring the rows above?
Thank you
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
AFAIK not possible. Any chance you can use a separate sheet with the
copied data?

--
Regards
Frank Kabel
Frankfurt, Germany

"MATT" schrieb im Newsbeitrag
...
I would like to create a Form Letter, importing data from an Excel

Spread
Sheet. On the first few rows of the Excel Spread Sheet is some data

not to
be moved, and several rows below the first row is the header row. Of

course,
when I go to merge into the document, the fields are not there

because it is
reading from Row 1. Is there a way to specify that the header row is

Row
"x", thus ignoring the rows above?
Thank you


  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Matt

Select data rows starting at header row and below.

Give this a range name. InsertNameDefine.

When in Word, browse to the file and you will be able to select the range by
name.

That range will be the merge range and will ignore the rows above.

Gord Dibben Excel MVP

On Thu, 2 Dec 2004 14:39:09 -0800, "MATT"
wrote:

I would like to create a Form Letter, importing data from an Excel Spread
Sheet. On the first few rows of the Excel Spread Sheet is some data not to
be moved, and several rows below the first row is the header row. Of course,
when I go to merge into the document, the fields are not there because it is
reading from Row 1. Is there a way to specify that the header row is Row
"x", thus ignoring the rows above?
Thank you


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
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
Chart appearance using "export" method Alex St-Pierre Charts and Charting in Excel 4 December 3rd 04 04:29 AM
Custom Header Josh O. Excel Discussion (Misc queries) 1 December 1st 04 07:56 PM
One header for all worksheets in workbook WillieR Excel Discussion (Misc queries) 2 December 1st 04 10:27 AM
Mail merge to a chart Alex St-Pierre Charts and Charting in Excel 1 November 28th 04 06:05 PM


All times are GMT +1. The time now is 12:14 PM.

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

About Us

"It's about Microsoft Excel"