vba - Outlook reply to multiple emails on demand -
just wondering if possible , if can assist me with?
in scenario emails comes shared folder. have email sorted.
after sorting start putting emails approved folder. have vba macro in outlook able generate custom reply emails in approved folder.
for example if place 5 emails in folder , run script should send emails out 5 senders.
the email generic such "you approved, please logout "time".
i'd suggest starting getting started vba in outlook 2010 article in msdn. explains basics of programming vba macros.
the itemadd event fired when 1 or more items added items collection (i.e. folder). aware, event not fired when large number of items added folder @ once.
so, can handle itemadd event of approved folder create , send reply. reply method of outlook items creates reply, pre-addressed original sender, original message. send method sends e-mail message. example:
public withevents myolitems outlook.items public sub initialize_handler() set myolitems = application.getnamespace("mapi").getdefaultfolder(olfoldercontacts).items end sub private sub myolitems_itemadd(byval item object) dim myolmitem outlook.mailitem dim myolatts outlook.attachments set myolmitem = myolapp.createitem(olmailitem) myolmitem.save set myolatts = myolmitem.attachments ' add new contact attachments in mail message myolatts.add item, olbyvalue myolmitem.to = "sales team" myolmitem.subject = "new contact" myolmitem.send end sub
Comments
Post a Comment