PDA

View Full Version : Solved: How to save the email attachment using vba



wakdafak
03-01-2012, 06:31 PM
i have a task here

can someone help me

situation:
i want to retrieve the email attacment and save it into the specific folder

help... :help

Kenneth Hobs
03-01-2012, 07:29 PM
What is the email program? What is criteria to do it? For all in the inbox, by Subject line, etc.

Some variation for sending might help:
'If locked out of CDO, install: http://www.dimastr.com/redemption/
'http://www.vbaexpress.com/forum/showthread.php?t=22439

or maybe, http://msdn.microsoft.com/en-us/library/ff458119%28office.11%29.aspx

IF you are dealing with Outlook, you should look in the Outlook forums. e.g. http://www.vbaexpress.com/forum/forumdisplay.php?f=18

wakdafak
03-01-2012, 07:32 PM
the criteria i have to retrieve the attachment from inbox
every email with attachment

the macro will be retrieve and save the attachment from the outlook

tq

Kenneth Hobs
03-01-2012, 07:47 PM
You might be able to get an idea from this. I don't use Outlook so it is hard for me to test these days.

wakdafak
03-01-2012, 08:58 PM
hye

i have run the macro
and the error occurs

MacroName: GetAttachments
Error Number: 424
Error Description: Object required :dunno

Kenneth Hobs
03-02-2012, 06:23 AM
That usually means that you don't have the object set in Tools > References. If you ran it from the workbook that I posted, then you probably have a listing of Missing which probably means that Outlook is not installed. Don't confuse Outlook with Outlook Express.

wakdafak
03-05-2012, 12:44 AM
hye mr kenneth

this macro that you give me looks great and working 100%

that for helping :clap: