Extracting attachment filename in lotus notes using VBA

[Nik32]

Hi,

I am new to lotus notes automation using vba.

I have a requirement wherein I have to loop through all the mails in the lotus notes DRAFTS folder and copy the filename of the attached file into an excel sheet.

HELP!!!


Thanks in Advance..

 

[John_w]

See if the code at https://www.mrexcel.com/forum/excel...file-lotus-notes-post2536910.html#post2536910 gets you started. Changing "($Inbox)" to "($Drafts)" should give you the Drafts folder, I think. aValues(0) is the attachment file name. The code saves the attachment, so just delete the GetAttachment and ExtractFile lines.