Excel Merge to Word (Word 2003)

[TheDon]

I have an Excel 2003 spreadsheet. See attachments. It has about 100 rows, I sent you the worksheet with only 5 records. I need a report that looks as follows in Word from Excel 2003:

Prefix First Name Last Name E-Mail E-mail
Company Expire
Address 1 Committees
City, State zip

Prefix First Name Last Name E-Mail E-mail
Company Expire
Address 1 Committees
City, State zip

Prefix First Name Last Name E-Mail E-mail
Company Expire
Address 1 Committees
Cith, State zip


That would be record 1, then record 2, then record 3 all on the same page. Not sure if it is a mail merge and don't know how to do it. Please send me the steps.

I need E-mail about 2 inches right of the Last Name field. I need Expire about 2 inches right of the Company field. I need Committees about 2 inches right of the Zip field. Sorta like to cloumns. When I sent it the 3 fields don't show up in the proper locate. I will try to show you how it looks in the Excel Spreedsheet. Please look there. Thanks in advance.

[macropod]

Hi,

You can do this in Excel itself, without resorting to Word.

To do this:
. Create a new worksheet in your existing Excel Workbook
. In cell A1 of the new worksheet, insert the formula -
=OFFSET(Board!$A$2,ROW()-1,0)&" "&OFFSET(Board!$A$2,ROW()-1,2)&" "&OFFSET(Board!$A$2,ROW()-1,1)&CHAR(10)&IF(OFFSET(Board!$A$2,ROW()-1,6)="","",OFFSET(Board!$A$2,ROW()-1,6)&", ")&OFFSET(Board!$A$2,ROW()-1,5)&CHAR(10)&OFFSET(Board!$A$2,ROW()-1,7)&" "&OFFSET(Board!$A$2,ROW()-1,8)&" "&OFFSET(Board!$A$2,ROW()-1,9)
. In cell B1 of the new worksheet, insert the formula -
="Email: "&OFFSET(Board!$A$2,ROW()-1,13)&CHAR(10)&"Expires: "&OFFSET(Board!$A$2,ROW()-1,31)&CHAR(10)&"Committees: "&OFFSET(Board!$A$2,ROW()-1,32)
. Copy cells A1 & B1 down as far as needed (eg 100 rows)
. Widen both columns to accommodate the longest line that will be required
. Format both cells for wrapped text
. Adjust the row heights to suit your output requirements.

Cheers