Help With Mail Merge From Excel 2000

[Tanya]

Hi there,

I have an Excel spreadsheet containing information I
would like to be able to use in a Mail Merge.

I require assistance in writing a Macro that will go to
the last record and then send that information into a
mail merge document in MS Word. Is this even possible?
Can I use Excel and Word together like that using a macro.

The spreadsheet contains Fields:
FirstName
LastName
Login
Account
Password
Administrator
Date

I would like to take the last entry in the spreadsheet
and then put it into a template already setup for a merge
in Word. When I try this, it will only merge every record
in the list.

Can this be done?

 

[Andy Brown]

Can I use Excel and Word together like that using a macro.

Probably. You can filter the table before merging so that only the filtered
record(s) merge. So I guess you could use a macro to find the value in one
of the fields in the last row, then autofilter by that value. But the value
would have to be unique
(?login?). Personally I wouldn't bother.

Say those field headings are in A1:G1. You could use formulas in a free area
of the sheet, eg:

=OFFSET($A$1,COUNTA(A:A)-1,0)

would return last FirstName,

=OFFSET($A$1,COUNTA(A:A)-1,1)

gets you last LastName, etc. You could arrange this on the sheet to suit the
required Word layout. Then you'd copy the formulas area and Paste Special in
Word, with Paste Link selected. The Paste Link should ensure that the last
row details always show.

HTH,
Andy

 

[David McRitchie]

Hi Tanya,
Certainly, you would be using MS Word with Excel as the "data base".

You did not provide information on if those
are across or down.

If each person is on a row then no macros are needed, you can start
directly at http://www.mvps.org/dmcritchie/excel/mailmerg.htm
mine is primarily for printing labels, but letters are similar and there
are references to pages of others more into letters.

If your data is in one column and has to be first put into spreadsheet
form see http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Tanya]

Thank-you so much David!!! Your suggestion finally opened
up the floodgates on this project. I owe you a great deal
of thanks!!

Thanks, thanks, thanks, thanks, Thanks!!!!!

-----Original Message-----
Hi Tanya,
Certainly, you would be using MS Word with Excel as the "data base".

You did not provide information on if those
are across or down.

If each person is on a row then no macros are needed, you can start
directly at http://www.mvps.org/dmcritchie/excel/mailmerg.htm
mine is primarily for printing labels, but letters are similar and there
are references to pages of others more into letters.

If your data is in one column and has to be first put into spreadsheet
form see http://www.mvps.org/dmcritchie/excel/snakecol.htm



"Tanya" <[email protected]> wrote in

message news:[email protected]...

 

[Tanya]

THANKS for the help. Your suggestions really helped me in
finally getting a grasp on this project.

Once again, thanks so much!!