How do you export database of names/addresses from proseries?
10/19/09 3:29 PM, Viewed by asker 10/27/09 11:58 AM
Total Views: 84
Is there a simple way to export database of names and addresses from proseries into an excel worksheet, or other kind of file that printer can use to do a mailing for me? Thanks,, Neal
Helpful Answer
You can export your HomeBase to Excel as a .csv file and then save it is as an Excel file, It will need some tweaking.
Answer
You can export your HomeBase to Excel as a .csv file and then save it is as an Excel file, It will need some tweaking.
Answer
In Home Base View / Form 1040 Individual / File / Print / Select from Home Base View on Left Side Client Labels and you have a choice of 2 column or 3 column..
My answer has nothing to do with exporting, but might get you the print outs you want and it is easy to print the addresses on labels if you are careful when you buy the labels.
Answer
I just did this last night, however, it took a bit of time to clean up my Excel file.
There's another thread/topic (that I can't seem to find right now) where somebody advised to open up your actual homebase file, with Excel, in the proseries directory on your comp.
Of course I didn't mess with the original file. So I took a copy of the homebase file and put it in my tax prep folder working files. I then opend it up with Excel and of course it looks overwhelming at first. But I took the time to clean it up and now I have a perfect Excel file of all my clients and all the info I need to go from there (filing status, form filed, name, address, tel #, refund $, etc.)
~Maria
P.S. I'm using PS Basic version. If you want help with the process I used, feel free to shoot me an email.
Answer
As Minbreno stated you can export and create a csv file and work with it then format it in excel. The response you received on how to print labels from Peterhawaii has nothing to do with your question you asked. Creating the CSV file and then formationg it in excel with allow you to create a mass mailing file that you can utilize in what is called a "Mail Merge Operation"
Comment
I now understand how to create the CSV file and export it. The standard view only includes the following, however doesn't include the STREET ADDRESS which is what I really need included. Any hints on how to create CSV file so it includes that? Greatly appreciate it.
Cheers, Neal
When the ProSeries program creates a CSV file, it includes the following information for all the clients that are included in the HomeBase All Tax Returns view:
Client file name and location Client name Type of return Telephone number
Email address SSN or EIN Status of the return Date last modified
Due date for the return Preparer City, state, and ZIP code Extension - Yes or No
The CSV file doesn’t include any tax return data.