Whether you're in Photoshop, Illustrator, or InDesign, just check the Window menu under "Extensions" for Kuler. If you don't have it, you can also browse and create using their free website. The process is effectively the same whether you're using the app from within CS6 or online, but I recommend launching it from CS6 so that you will be able to seamlessly add any color schemes you find or create into your swatches panel.
Kuler's slick web-based interface
Once you get started, the process is simple: you can search keywords, browse the latest and greatest themes, or take inspiration into your own hands with an intuitive color wheel that lets you set rules and create a beautiful design with minimal time and effort.
My five-second color scheme using Kuler's wheel
If your design is looking drab and you think the colors may be to blame, spend some time on Kuler and see if you can't find a theme that brings it to life. It's saved my life time and time again, and I hope it helps you too!