I was working on finalizing one of my macros, when all of my macro
stopped working. They all involve emailing at the end so I figure
that was it.

When I try to run one it comes back and says

"Compile Error: Wrong number of arguments or invalid propert
assignment"

It then comes back and highlites the word "Format" on this line.

olMail.Subject = "Daily Reports from " & Format(Date - 1, "mmm-dd-yy")

If I get rid of the word Format, it selects format on another line.
have the Outlook reference checked as well as the Applicatio
extensibility.

Does anyone have any idea what could have gone wrong? I'm now unabl
to generate any of my reports!

Any help would be great!

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=57177