Advanced search

Anyone know how to use address lists in Excel?

(5 Posts)
MrsThierryHenry Thu 09-Oct-08 10:20:31

I have inherited a contact list which was created in Excel. This week I have created an invoice also in Excel, and I now need to pull through the addresses from the database so that they appear automatically in the invoice.

Is there some way that I can do this? Or would it be better to just use a different application altogether?


IotasCat Thu 09-Oct-08 10:22:38

I would create the document in word and use mail merge

MrsThierryHenry Thu 09-Oct-08 10:24:27

Yessss...I can see this is going to create lots more work for me than I'd like...!

MrVibrating Thu 09-Oct-08 15:35:09

No, don't do it in word, excel is perfect for this, but it is much easier to do than explain.

Best explanation I can find in a hurry is here.

Or just search for 'match and index'.

MrsThierryHenry Thu 09-Oct-08 20:52:19

Wow, thanks for that MrVibrating (hmm..interesting name)! I'll take a good hefty look at that.


Join the discussion

Registering is free, easy, and means you can join in the discussion, watch threads, get discounts, win prizes and lots more.

Register now »

Already registered? Log in with: