This gets asked from time to time in the forums so I wrote a sample code about it:

HOWTO: Get the output build folder from a Visual Studio add-in or macro
http://www.mztools.com/articles/2009/MZ2009015.aspx