Ahh, I see. I'll give that a go. Does he actually have to find something that exists in the game world - which I could pick up myself if I found it - or does the act of sending him off spawn something new for him to find?
He'll only find items that exist in the game world - sending him out to find stuff won't cause it to spawn. One thing he can do, though, is bypass locks on containers. So if your lockpick skill isn't high enough to get at a weapon or some ammo in a locked cabinet or box, Dogmeat can still get the item for you.
Be careful using him in open areas - as noted above, he can wander far away from you looking for items and take a long time to catch back up to you (unless you're playing on the PC and can use console commands to move him to you).