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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.