Save outlook attachments to different folder paths based on Domain Names

**amb2301** · 08-09-2021, 07:42 PM

Hi All,
Rules & Alerts not works in shared mailbox, i found a script from internet, which works perfectly in shared mailbox as per my requirements,

but here i need a small changes to be made on that script as follows,

if i receive email from domain name personname@abc.com then attachment should get saved to path 1 (C:\users\Input\abc\)
if i receive email from domain name personname@efg.com then attachment should get saved to path 2 (C:\users\Input\efg\)
if i receive email from domain name personname@xyz.com then attachment should get saved to path 3 (C:\users\Input\xyz\)

Could someone please help me on it...

Please Login or Register  to view this content.

**Artik** · 08-09-2021, 07:57 PM

Should the macro copy attachments only for those three aforementioned domains? What if an email comes from the *@aaaaa.com domain?

Artik

**amb2301** · 08-09-2021, 07:59 PM

Originally Posted by Artik

Should the macro copy attachments only for those three aforementioned domains? What if an email comes from the *@aaaaa.com domain?

Artik

Sir,
Thanks for looking on this thread,
If email received from other than these 3 domains, it can be ignored.

**Artik** · 08-09-2021, 09:06 PM

Please Login or Register  to view this content.

Artik

**amb2301** · 08-09-2021, 10:05 PM

Originally Posted by Artik

Please Login or Register  to view this content.

Artik

Thank you so much for the code Sir, now code its reading the domain names
but it reads only one email & rest of the unread emails are not getting processed.

some of the lines got removed between here...

could you please have look on it sir

Please Login or Register  to view this content.

**amb2301** · 08-09-2021, 10:08 PM

also earlier script will save only "xlsb" format files, but now its saving all type of attachments inside path ..

**Artik** · 08-09-2021, 11:44 PM

Originally Posted by amb2301

now code its reading the domain names
but it reads only one email & rest of the unread emails are not getting processed.

Code analysis shows that it should process all messages, but only cares about unread messages. In unread it checks if they contain attachments. If they do, the attachments are copied to the appropriate folders on the disk and the message is moved to the "Processed" folder in Outlook. Unread messages that do not contain attachments remain in the "personal folder".

Originally Posted by amb2301

some of the lines got removed between here...

In the code you are presenting, this line

Please Login or Register  to view this content.

does nothing (dirName is not used later), so I removed it. If we are only interested in *.xlsb attachments, then the fragment of my code should be changed to the following

Please Login or Register  to view this content.

However, if unread messages (regardless of their content) were to be moved to the "Processed" folder, change the fragment like this:

Please Login or Register  to view this content.

Artik

**amb2301** · 08-09-2021, 11:46 PM

Thanks Sir, I came outside for breakfast....will check & update you in an hour

**Artik** · 08-09-2021, 11:50 PM

And I'll finally go to sleep.

Artik

**amb2301** · 08-10-2021, 04:39 AM

Sir,
as per your updated code, i tried in my outlook, it moves all the unread emails to Processed folder, but none of the attachments getting saved in local drives..
could you please have a look on it Sir,

Please Login or Register  to view this content.

**amb2301** · 08-10-2021, 05:03 AM

Sir,
i tried running the code in f8 mode, i found that its skipping these lines

Please Login or Register  to view this content.

i added this line to the code
dirpath = "C:\users\Input\"

**kvsrinivasamurthy** · 08-10-2021, 08:33 AM

The Result of line may be false.
If CheckDomain(mi.SenderEmailAddress, dirpath) Then
This link may help.

https://contactform7.com/configurati...n-site-domain/

**amb2301** · 08-10-2021, 09:51 AM

Sir, Thanks for looking on this Thread,
i made few changes, so its working & attachments are getting saved in respective paths,
but a new problem here is ....its moving Read emails also to the processed folder, it should not happen,
sir, could you please check & tell me ....where i made mistake ...
Note: its working based on the email attachments

Please Login or Register  to view this content.

**kvsrinivasamurthy** · 08-10-2021, 10:39 AM

Try this
Change this

Please Login or Register  to view this content.

as

Please Login or Register  to view this content.

**amb2301** · 08-10-2021, 07:11 PM

Thank you so much for the code sir , it worked perfectly

**kvsrinivasamurthy** · 08-11-2021, 02:33 AM

Ok. Thanks for feed back.

Save outlook attachments to different folder paths based on Domain Names

LinkBack

Thread Tools

Rate This Thread

Display

Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Re: Save outlook attachments to different folder paths based on Domain Names

Thread Information

Users Browsing this Thread

Similar Threads

Monitor Outlook sub folder and save attachments to file

Save attachments in folder based on date of email.

Outlook Macro to save attachments to system folder with Date at end

Save all attachments macro from certain folder and move processed e-mail to another folder

Save Outlook attachments to a folder.

Wants to mail on different ID attachments from a folder through Outlook

Loop through a specific folder in OUTLOOk and save the attachments to another folder?

Bookmarks

Bookmarks

Posting Permissions