SendObject MACRO Problem?

[mishbaker]

Hey guys,

I'm having a problem with a SendObject macro. I am having it make a table into an HTML file and email it to whoever@wherever.com. It works fine the first time I run te macro but the next time I try it doesnt work. I have to completely close out of the Database and open it again. I've tried to use a "StopAllMacros" macro just in case it was hanging or something......but that didnt help any. I'm not sure what else the problem could be. Any help would be appreciated.

Thanks,
Mish

Learning VBA through your expert tutelage!

 

[Trendsetter]

When you close the application and rerun you are reinitialising the macro which would suggest that some data from the initial action is stopping the process repeating - it may be that the table is seem to be null or is already in the HTML format or that address component is blocked. A macro cannot be debugged so it is very difficult to analyse what is happening - in code you could walk through to locate the fault!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[mishbaker]

So I need to code it huh. Damn. I was going for quick and painless.

Learning VBA through your expert tutelage!

 

[Trendsetter]

Quick is nearly always pained!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk