How can I generate a mailing labels and invoices from a contact list?

[skelyrata]

Hello. I hope I posted this in the rigth forum. If not, I apologize.

I have a problem for which I haven't found a real solution but I am sure there has to be one so here I am praying you guys can point me in the right direction.

Firsty of all my knowledge of Excel is intermediate and NONE for macros.

I started at a new job.

They have a spreadsheet with conctact information divided into columns by company, contact name, email, tel, division, address on sheet # 1.

Every year they send invoices to those companies, but they create the labels and the invoices kind of mannually, I mean they go to sheet # 2 and they create the mailing labels by referencing to the cells one by one, for 150 companies. They do the same thing for the invoices on sheet # 3. I mean it takes like three days to update all that.

Now I am sure Exel must have a very easier and quick way to generate labels and invoices but I have googles around and haven't found the right formula or commands.

Can anybody help me here?

[FDibbins]

Hi, welcome to the forum

It would probably be easier if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like. That way we can see what you have, and what you want

[Ursul]

Hi and welcome to the forum,
You could do a 'mail-merge' into MS Word. Mail-merge in Word from an Excel database works very well and is easy BUT the database in Excel must be complete without any gaps or empty cells within the range. In Word, go to the 'Mailings' tab and then click on the 'Start Mail Merge' button, then select 'Labels'. A dialog box will open and here you will have the choice as to which label you will use - depending upon which label you use there may be eight or twenty per page. But at least this way you can print them all at once. Once you have the label, click on the 'Select Recipients' button and select 'Use existing list' (your Excel database) and away you go importing and setting up the fields. Job done! Cheers

[Ursul]

Now concerning the Invoice - that's a little trickier, but again you can do the same thing using mail-merge. But first you need to create an Invoice in MS Word, with gaps left for the 'fields' that will be imported. These fields will be the name and address, maybe details and obviously the amounts. But again your database for this will need to set up clearly and precisely. So one invoice created in Word and you could with Mail-merge print out the invoices to all your clients in one hit. It's easy if you know how, but then again isn't everything! All the best! Cheers