1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Converting excel rows (addresses) to columns for mail merge

Discussion in 'Business Applications' started by LCarter869, Sep 13, 2009.

Thread Status:
Not open for further replies.
  1. LCarter869

    LCarter869 Thread Starter

    Joined:
    Sep 13, 2009
    Messages:
    1
    Ive spent so much time on this, I want to pull my hair out.

    I have a pdf file of addresses. I converted the pdf to an excel file (the one I uploaded).

    My eventual goal is to convert the addresses into excel, then do a mail merge into word.

    I found a tool (via this great site) called ASAP utilities that I can turn the rows into columns, thats easy.

    But the problem is, the addresses aren't always the same length. Some labels are 4 rows, others are 6 rows.

    Is there any way I can either automatically make the rows 6 each without doing it manually? Or does anyone have any type of suggestion?

    Thanks so much for the help
     

    Attached Files:

  2. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Firstly, can I assume that you have permission to use those addresses for your own mailing?

    If so you could go back to the originator and ask them to give you a CSV file, or maybe see if the pdf file can be saved as a CSV file.

    If so, it would be very easy to bring that into Excel and then convert the file from text to Columns, using the Data, Text to Columns feature.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/860585

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice