Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Blank Cells in Address fields

Options
  • 20-06-2012 12:39pm
    #1
    lobber
    Registered Users Posts: 163 ✭✭


    I am cleaning up a list of addresses (2300 of them) for a mailing.
    I need to remove blank cells or getr the cells to fill across.
    Anyone have any insight into how to do this without manually dragging and dropping each one?


Comments

  • Options
    #2
    FSL
    Registered Users Posts: 1,456 ✭✭✭FSL


    Most mailing programmes/options (e.g. mail merge) will ignore blanks when formatting the address.

    For example an address record may consist of Title, Initials, First Name, Last Name, Address Line 1 .....Address Line 5, County, Post Code, Country etc.

    You determine which fields go on which line and the programme ignores blank lines.


  • Options
    #3
    lobber
    Registered Users Posts: 163 ✭✭lobber


    FSL wrote: »
    You determine which fields go on which line and the programme ignores blank lines.

    Not getting that unfortunately as it is leaving a line space between each one.


Advertisement