i trying run macro via rule in outlook saves attachments folder.
emails have more 1 attachment. trying save files in order, example if go down emails can see file corresponds it.
i have following found online:
public sub saveattachtodisk(itm outlook.mailitem) dim objatt outlook.attachment dim savefolder string savefolder = "c:\pathtodirectory\" dim dateformat string dateformat = format(itm.receivedtime, "yyyy-mm-dd hmm ") each objatt in itm.attachments objatt.saveasfile savefolder & "\" & dateformat & objatt.displayname next end sub i've tried play objatt.displayname no luck. i've tried assigning new names , creating new loop names files file 1 , file 2 , on when lose file extension.
updated version:
option explicit public sub save_attachments(itm outlook.mailitem) dim fso object set fso = createobject("scripting.filesystemobject") dim strext string dim long dim savefolder string = 1 savefolder = "c:\users\w\desktop\test" each objatt in itm.attachments = + 1 strext = fso.getextensionname(objatt.displayname) objatt.saveasfile savefolder & "\" & dateformat & " - file " & & "." & strext next end sub
you in existing subroutine. increment "file" number , still preserve extension.
dim fso object set fso = createobject("scripting.filesystemobject") dim strext string dim long each objatt in itm.attachments = + 1 strext = fso.getextensionname(objatt.displayname) objatt.saveasfile savefolder & "\" & dateformat & " - file " & & "." & strext next
Comments
Post a Comment