OMG... PROBLEM SOLVED...
I hate how you have to search 30 different wordings of your problem on the net to finally land the jewel that explains everything...
The problem was with lotus notes... if the attachment process fails, it stores a temp file in your temp directory with the file name...
I have Access 2003.
I'm e-mailng a report in snapshot form with the following code in VB:
DoCmd.SendObject acSendReport, strReport, acFormatSNP, strEmailAddr, , , strEmailsubj, strEmailMsg
This code works when fired off some of my forms, but one form is making the report attach as CDB47.xls...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.