Im trying to create myself an easier way to do invoices. I’ve converted from Word to Excel to do this and started using templates, rather than just editing old invoices to create new ones.
The problem i have is that by using an excel template i have to enter the customers name & address each time i write an invoice, with takes a long time and effecitvely negates the entire point of this exercise – i.e to SAVE time.
What i would like to be able to do is import external data (the name and address mainly) from another excel sheet or someting like Outlooks contacts database straight into this excel template. kinda like you can do with a mail merge in word. I have access installed, but am a complete novice with that so id like to avoid it unless absolutely necessary.
If it helps ive got Office 2k and windows 2k.