Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2006
    Location
    Dublin, Ireland, Republic of
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create mail list - help (excel 2000)

    Huge screenshot moved to zip file by HansV - please don't post pictures larger than 640x480

    Hi, I have a worksheet with details of up to 10,000 customers. Col 1 has customer name(in merged cells), Col 2 has address on multiple rows, Col 3 has details,
    Col 5 has, phone, fax, email and www details on seperate rows. (I attach a screen shot)

    What I want to do is create a mail list from this, where I have all the details on one row, name, address 1, address 2, etc.. similiar to the format required to carry out a mail merge.

    Any help apreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create mail list - help (excel 2000)

    Could you attach a small sample workbook (zipped if necessary)? That'll give Loungers who want to help something to try out their ideas on.

  3. #3
    Lounger
    Join Date
    Apr 2006
    Location
    Dublin, Ireland, Republic of
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create mail list - help (excel 2000)

    Attached is a sample of the worksheet. (Zipped)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create mail list - help (excel 2000)

    See the attached version. I added a new worksheet and a macro to populate it.

  5. #5
    Lounger
    Join Date
    Apr 2006
    Location
    Dublin, Ireland, Republic of
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create mail list - help (excel 2000)

    Thanks Hans, this is exactly what I require.

    Apologies for nto responding earlier, I was on vacation.

    Regards

Posting Permissions

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