Encore Forums Encore Forums

Knowledgebase  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Export Address Book info to MS Excel Spreadsheet

 
Logged in as: Guest
  Printable Version
All Forums >> [Product Forums] >> [Productivity Software] >> [The Print Shop 23.1 and older] >> PS Export/Import >> Export Address Book info to MS Excel Spreadsheet Page: [1]
Login
Message << Older Topic   Newer Topic >>
Export Address Book info to MS Excel Spreadsheet - 11/2/2009 2:08:29 PM   
purpleowl

 

Posts: 3
Joined: 10/26/2008
Status: offline
I need to prepare reports of Address Book (UMM) information in Excel Spreadsheets to submit via email to another organization. Does anyone know if/how this can be done? The standard "Spreadsheet" format report that is done in Address Book is useless, as it can't be saved, manipulated, exceed 10 columns, etc.

HELP
Post #: 1
RE: Export Address Book info to MS Excel Spreadsheet - 11/2/2009 4:11:57 PM   
ellengard


Posts: 3241
Joined: 10/2/2006
Status: offline
quote:

ORIGINAL: purpleowl

I need to prepare reports of Address Book (UMM) information in Excel Spreadsheets...The standard "Spreadsheet" format report that is done in Address Book is useless, as it can't be saved, manipulated, exceed 10 columns, etc.

It's an Address Book for the purposes of mail merging - it's not like it's MS Access.

You can export all the data in the Address Book as a tab delimited file. Use Excel to import that file and then do your Excel thing. (Access is a better program for data manipulation and reporting.)




Attachment (1)

< Message edited by ellengard -- 11/2/2009 4:20:40 PM >


_____________________________

my desktop publishing tips
Print Shop guest blogger(2014-20)

(in reply to purpleowl)
Post #: 2
RE: Export Address Book info to MS Excel Spreadsheet - 11/11/2009 9:23:07 AM   
purpleowl

 

Posts: 3
Joined: 10/26/2008
Status: offline
Thank you very much for your assistance. I'll try the tab delineated for this project and then consider changing to MS Access.

(in reply to ellengard)
Post #: 3
RE: Export Address Book info to MS Excel Spreadsheet - 11/11/2009 10:03:41 AM   
purpleowl

 

Posts: 3
Joined: 10/26/2008
Status: offline
I followed your suggestion. It was quite simple, actually. Took about 30 seconds to get the spreadsheet I need.

Again, Thank you very much

(in reply to ellengard)
Post #: 4
RE: Export Address Book info to MS Excel Spreadsheet - 11/11/2009 10:31:05 AM   
ellengard


Posts: 3241
Joined: 10/2/2006
Status: offline
You're welcome!

_____________________________

my desktop publishing tips
Print Shop guest blogger(2014-20)

(in reply to purpleowl)
Post #: 5
Page:   [1]
All Forums >> [Product Forums] >> [Productivity Software] >> [The Print Shop 23.1 and older] >> PS Export/Import >> Export Address Book info to MS Excel Spreadsheet Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Please Note: In order to post a message on the forums, you will need to become an Encore Forum Member. Click on the Register link on the top of this page and follow the instructions to become an Encore Forum Member.

If you are a new member and need help using these forums, please click on the FAQ link at the top of this page.

Forum Software © ASPPlayground.NET Advanced Edition 2.4

1.029