Don't know how you could make it one click if your Excel list changes every week.
But I was talking about sending messages directly from the buddy list not using the stand alone private message where you have to select a person and click add one at a time from the buddy list.
On the buddy list you just place a check mark on each person then select send message to all selected.
So as far a clicks go that would be one click for each person and one click to create the message and one click to send.