#1
|
|||
|
|||
Populate cells in Word from a database
I'm using MS Word 2007 to create a simple "billing statement". What I would like to do is to be able to select an "organization" name from a pull down menu, and depending on that choice, other cells in the WORD document would populate according to a database of my clients information. I'm guessing this database would come from Excel (which I could make if so). For now, I have a few "drop down lists" for certain fields, but I would prefer to have predefined cells populate according to a database. A graphical example is at http://www.shan-dysigns.com/billing.jpg
I would like the drop down menu "organization" to populate the fields with circles. |
#2
|
|||
|
|||
Hi hotlilshan, can I ask why are you using word 2007 for you invoicing? MS Word is certainly not the application for this. Either use MS Excel for a simple invoice and populate the information using vlookups or use the correct tool for the job.....Access.
|
#3
|
|||
|
|||
I'm sure MS Word isn't even close to the proper app to use for invoicing, but in the beginning, I didn't need anything extravagant. At the time, I just wanted to have something on paper to show who I billed and what I billed them. My business has grown quite a bit since then, and I've constantly battled with which way I should go in order to create a real business invoicing environment (without having to spend too much time dealing with it) - that's why I chose Word in the beginning because I don't want to take too much time outside of my actual work just to set up a billing environment. I had originally created a bill in Excel and ended up pasting it into Word, and have always stuck with Word from then on. I will try Excel again... thanks
|
#4
|
|||
|
|||
Excel is still not the best solution
Excel will get you half way there. You should be aiming to access for the future. It's designed to work with historical data with excellent reporting and security features in a multiuser environment.
|
Tags |
cell, data, populate, word |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to stop correcting zeroes in cells ? | kevin_ms | Excel | 4 | 09-14-2008 10:08 PM |
How to get cells to calculate time? | jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Nested if formulat to merge cells | cristi22 | Excel | 0 | 10-23-2006 08:28 AM |
Populate an empty .PAB file | imported_contiw | Outlook | 2 | 08-17-2006 08:50 PM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |