Which is better? a macro lens or the macro mode on my nikon D40?

i'm trying to decide if i need to get a telephoto lens with macro in it also. I have macro mode on my cameras, but I dont use the mode a lot, but i've heard macro lenses are amazing. I don't know if I should get the lens with both zoom and macro, or get a telephoto lens and just keep using macro modes on my cameras....