98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Office general help » Address database | Lables
Address database | Lables
Resolved · Low Priority · Version 2007
Eliza has attended:
PowerPoint Intermediate Advanced course
Address database | Lables
Hi there,
I would like to know if it is possible to create a document of address lables from Outlook?
I want to build a christmas card address database and export the data to word address lables. Is this possible?
Equally, as I have not started to build the database yet, can you advise of the easiest most suitable way to create address lables every year into a database that will continually be updated.
Looking forward to hearing from you.
Kindest regards,
Eliza
RE: Address database | Lables
Hi Eliza
Thanks for getting in touch. Yes, this is possible.
In Word, go to Mailings > Start Mail Merge > Labels. Choose the label type based on the brand of label paper you use. Then go to Select Recipients > Select from Outlook Contacts.
From here the wizard should guide you through the process of marrying up names and addresses etc.
If you want to start this process from scratch, personally I would do it in an Excel spreadsheet. Set up a new file with some headings (First Name, Last Name, Street Address etc) and fill it in this way. This has a document which multiple people can access and work with and you will probably think of other things you can do with this data.
To use this data you would perform the process above but instead go to Select Recipients > Use Existing List. Browse to your Excel file from here.
I hope this helps.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Address database | Lables
Hi Gary,
Many thanks for your reply.
I am making progress but I am struggling to create the full document.
I can create one label but not a whole document.
Is there a way that I can insert fields all over the document and not just on one label -hope this makes sense.
Thanks
Eliza
RE: Address database | Lables
Hi Eliza
Thanks for your reply. Have you tried the link in Rodney's reply below?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Address database | Lables
Hi Gary or Rodney,
I don't suppose you can take over my machine using Log Me In or similar.
I know I am only one click away from achieving this.
Many thanks
Eliza
RE: Address database | Lables
Hi Eliza
After creating your first label, press the Update Labels button to push the changes throughout all your labels.
Finish & Merge will then complete the job.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Address database | Lables
Hello Eliza,
Hope you enjoyed your Microsoft PowerPoint course with Best STL.
Thank you for your question regarding developing a database of addresses from Outlook to produce labels.
I would use Mail Merge in Word to achieve this.
Here is a link to help you out with this:
http://office.microsoft.com/en-001/word-help/create-and-print-labels-for-a-mass-mailing-HA010109161.aspx
Give this a try!
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft Office tip:Standard Function KeysFunction keys are quick ways of completing certain operations in software packages, but tend to vary from package to package. |