Mail merge with excel data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bronxbabe - 06 Dec 2006 00:37 GMT

i'm trying to do a mail merge using excel data. my problem is that my first
row (in excel) has data in it that cannot be deleted, but it is NOT my
header/label row. the second row has the labels (last name, first name,
etc...) but, i need the first row because it has a date, which is used in
the formulas to calculate ages, lengths of employments, etc... If i delete
this first row, most formulas revert to "REF" marks. If I run the merge as
is, when the table is displayed, it is labelled as F1, F2, F3,... and there
are more than 500 columns altogether. (I have unchecked the option: "First
row of data contains column headers" in the Select Table dialogue, but same
results.) Any suggestions,

p.s. copying the table into word to generate merge a lot of work since
there were multiple tabs being used.

Thanks in advance,

Reply to this Message

macropod - 06 Dec 2006 01:40 GMT

Hi bronxbabe,

A fairly simple workaround would be to cut your first row and paste it onto
another worksheet, then delete the first row.

Cheers

Signature

macropod
[MVP - Microsoft Word]

> i'm trying to do a mail merge using excel data. my problem is that my first
> row (in excel) has data in it that cannot be deleted, but it is NOT my
[quoted text clipped - 11 lines]
>
> Thanks in advance,

Reply to this Message

bronxbabe - 06 Dec 2006 04:20 GMT

thank you, thank you, thank you. it helped a great deal.

> Hi bronxbabe,
>
[quoted text clipped - 24 lines]
> >
> > Thanks in advance,

Reply to this Message

Peter Jamieson - 06 Dec 2006 02:04 GMT

You can try the following:
a. before you merge, in Excel select the entire sheet except for the first
row and use Insert|Name|Define to create a range name (Let's sau "mydata"
b. In Word, go through the process of connecting to the spreadsheet, and
(if you are using Word 2002/2003) "mydata" should be presented as one of the
possible "tables".

Peter Jamieson

> i'm trying to do a mail merge using excel data. my problem is that my
> first
[quoted text clipped - 17 lines]
>
> Thanks in advance,

Reply to this Message

bronxbabe - 06 Dec 2006 04:21 GMT

Thank you very much. I tried both and this way helped as well.

> You can try the following:
> a. before you merge, in Excel select the entire sheet except for the first
[quoted text clipped - 25 lines]
> >
> > Thanks in advance,

Reply to this Message