Error #1004 routine send emails
 

My company uses an Excel spreadsheet that will auotmatilly post to our
intranet and send email notifications to people letting them now the posting
is out there. I am using Office 2007 and everyone else is using Office 2003.
When I hit the post macro, I get the following error. €œError #1004 was
generated by routine send emails€� the document will post but no emails are
sent.
I spoke with the person who created the spreadsheet and he has no clue as to
why I am getting this error.
Any help will be greatly appreciated.
Thanks