Run time error 2024 3

[jivetrky]

I found some VBA code to send an email with a report as an attachement. I am getting a run-time error 2024.

The report snapshot was not created because you do not have enough free disk space for temporary files.

What am I missing? Here is the code.

DoCmd.OutputTo acOutputReport, "Issues", "Snapshot Format", "C:\TEMP", False

Set outl = CreateObject("Outlook.Application")
Set mail = outl.CreateItem(olMailItem)
mail.To = "scshumate@bbandt.com"
mail.Subject = "Budgets"
mail.attachments.Add "C:\TEMP"
mail.display
SendKeys "^{ENTER}"

Set outl = Nothing
Set mail = Nothing

 

[ThomasLafferty]

It's probably not your code. Right click your start button and select Explore. In the address bar, enter [!]C:\Temp[/!] and press enter.

Once the folder opens, click View>Customize this folder. This should show you how much disk space it is using. You may have to delete some files...

Hope this helps.

Tom

Live once die twice; live twice die once.

 

[payback]

I also had a similar message (but can not remember the error number) when the name of my saved report was too long.

 

[jivetrky]

I thought of that myself. I'm confused because I am using 0 bytes in my temp folder.

 

[jivetrky]

I don't think its the length of my report name. It is called ISSUES, which is less than 8 digits. Any other ideas? I appreciate your suggestion.

 

[ZmrAbdulla]

You are not refering to the file but folder.

    DoCmd.OutputTo ObjectType:=acOutputReport, _
                   objectname:="Catalog", _
                   OutputFormat:=acFormatSNP, _
                   OutputFile:="C:\Temp\Catalog.snp", Autostart:=False

or simply

DoCmd.OutputTo acOutputReport, "Catalog", acFormatSNP, "C:\Temp\Catalog.snp", False

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jivetrky]

That worked. Is there anyway I can send it to a word document instead of saving it as a snapshot?

 

[ZmrAbdulla]

Not *.doc but *.rtf

These are the formats available

acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS

See more on help on topic "OutputTo Method"

You can delete the saved file from the disk after sending a copy
See "Kill Statement" in VBA help

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jivetrky]

Thank you I appreciate it.