Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Transfering Addresses from excel to word

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i want to be able to take these 900 addresses that i have and transfer them to word to print mailing lables. Data ranges from A1:H1. fname, lname, address1,address2, blahh blahh... Is there a macro, or an option to do this that i just don't know about? Please help
    i want them in a different format, not just copy and paste


    -andrew

    [ This Message was edited by: INSman on 2002-05-08 11:55 ]

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe this is too obvious but:

    Copy the data range including the field names that you want.
    Open Word and paste the cells.


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    North Wales Coast, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I would suggest leaving the data in Excel, give the columns appropriate headers,
    Name, Surname, Address1, Address2, etc..
    Goto Word - Tools - Mail Merge - Main Document Mailing Labels - Get Data .. Open Data Source - browse PC for Excel file - Open File .. (try Entire Spreadsheet option) Set up Main Document check settings OK .. Insert Merge Fields on next screen .. Then Merge
    I hope this rather disjointed explanation gives you an idea that it is possible. Have a go and if you get stuck please post again.
    Regards
    S

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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