You are really the only one who can make the right choice...and you haven't given us much info, so it's hard to make any recommendations. Also, what's your budget? I know some nice telephoto lenses but they are over $10,000.
I always suggest the 50mm F1.8 lens. It's cheap ($70 US), although the body is mostly made of plastic. However, the optics are fantastic and the fast F1.8 aperture is really nice for shallow DOF and low light photography.
I think the most common Macro lens is the 100 F2.8 Macro. It's a nice focal length for portraits...but might be a little long on the 350D. I think they make a 60mm macro lens that is EF-S (will work on the 350D, 20D, 30D...but no other Canon cameras).
There are other options of macro photography. You could get a set of extension tubes. They would go nicely with a 50mm. You could get a set of diopter close-up filters. They just screw to the front of any lens. The image quality is not all that great, but they are much cheaper than a macro lens.
As for telephoto, the entry level lens is the 70(or 75)-300. There are a few different models at different prices. The most affordable ones are less than $300. There is a model with IS (image stabilization) which is great because it will help you take sharper shots when the light is less than perfect. It's expensive though.
There are some 70-200 lenses. One model is the F4 and one is the F2.8
The F2.8 is much bigger and more expensive but it's supposedly a fantastic lens. Sigma also makes a pretty good 70-200 F2.8
A really good telephoto zoom is the 100-400 L. "L" is Canon's designation for it's best lenses. They are the cat's meow but will cost an arm and a leg.
There are also 300mm and 600mm prime (non-zoom) lenses. But they are fairly expensive as well.
If you can, go into a camera shop and ask to try the different lenses on your camera. Take some shots and then go home and compare the images. This will give you an idea of the focal lengths, the balance and hold-ability of the lens on the camera and the image quality.