New System!
I am designing a new system for a band. The system must hold all gig details, customer profiles, stock information, and there must be a mail merge feature and balance sheet in their somewhere!
I have to use Office 95, access, word and excel!
Where do I start.
How am I going to link the database to the mail merge and link the balance sheet in excel?
Get back to me.
Steve.
Peter J. Boettcher posted this at 13:45 — 9th January 2001.
They have: 812 posts
Joined: Feb 2000
Steve,
I don't have to much experience working with databases within the Office environment. I know it is possible to call and create any Office object (Word, Excel, etc) from within the Office application via VBA.
I'm not sure how you would do the mail merge without programming. You would probably need a little VB app to do that. For the balance sheet in excel you could probably use the Access database directly, or if that didn't work, try saving the Access database in text format and then import it into Excel.
Sorry I couldn't be more help, but my experience is mostly on the Web side.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.