vba - Capture the event while moving the mail from subfolder to inbox -


i have requirement capture event when mail moved subfolder inbox

the folder structure below

myarchive-mailbox name inbox main folder   requests sub folder  myarchive    inbox       requests

when email moved requests subfolder inbox, of myarchive mailbox name ,this mailbox item should captured , event handler should invoked.

i have implemented code capturing event when file moved myarchive inbox requests.the code have written below

private withevents items outlook.events  private sub application_startup()      dim olapp outlook.application     dim objfolder outlook.mapifolder     dim objns outlook.namespace      set olapp =outlook.application     set objns =olapp.getnamespace("mapi")     set objfolder = objns.folders("myarchive")     set objfolder=objfolder.folders("inbox")     set items=objfolder. folders("requests").items  end sub  private sub items_itemsadd(byval item object)   msgbox "you moved mail requests folder" end sub

the folder object has beforeitemmove event. in thisoutlooksession module, declare folder object withevents expose events.

private withevents marchreqs folder  public property set archreqs(olfldr folder)     set marchreqs = olfldr end property  public property archreqs() folder     set archreqs = marchreqs end property

next have set folder want watch. here set folder when application starts up.

private sub application_startup()      set me.archreqs = application.getnamespace("mapi").getdefaultfolder(olfolderinbox).folders("requests")  end sub

finally, can write beforeitemmove event procedure.

private sub marchreqs_beforeitemmove(byval item object, byval moveto mapifolder, cancel boolean)      debug.print item.subject     debug.print moveto.name  end sub

Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more