(NEWBIE)
I have a mailing list I put together of the last several months; over 2000+ Name and Addresses. How do I configure my list in a fast/quick/easy way in to the right format using Excel or some other type of computer software? I need for this same list to be corrected/modified by adding the necessary commas within the right areas for importing into a Mailing Software. Would I have to manually add the commas (comma delimited) in the right areas one-by-one using Excel or is there a software out their - that will do that for me fast and automatically (so-to-speak)?
EXAMPLE OF THE CORRECT FORMAT I AM LOOKING FOR: ABC Company, 1234 Jones Blvd, Las Vegas, Nevada, 89119, abc@yet.net
REQUIREMENT: I need six fields/grids: Company, Street/Mail Address, City, State, Zip-code and Email Address – ALL separated properly with a comma in the right areas.
Here is a sample of my list (Names & Addresses Have Been Modified For Privacy Issues):
ABC Fraternity - 1160 Peachtree Street, NW, Suite: 1604, Atlanta, Georgia 30303
Good Day - 2003 Saint Paul Street, Baltimore, MD 21218 - support@apa1123.net
Westgate Services, 2311-24 North Broad Street, Philadelphia, PA 19132-4590 - info@kappaaweqsi1911.com
Omega Fraternity, Inc. - 3221 Snapfinger Parkway, Decatur, Georgia 30035 - info@osdpf.org
Walstore Inc. - 105 Kennedy Street, NW Washington, DC 20011-5294 - info@ibfghsigma1914.org
Sigma, Inc - 7022 Commerce Street, Suite 620, Dallas, Texas 75202
Cookie - Founders Hall, 1600 N. Calvert Street, Baltimore, MD 21202 – grandpo234@iotaphitheta.org, grandvice567@iotaphitheta.org
Bookmarks