Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Merge to Word (Word 2003)

    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.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Excel Merge to Word (Word 2003)

    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
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •