Controlling Outlook from Excel

[tiredofit]

Using VBA in Excel, it is possible to control Outlook but to what extent?

The problem I have is as follows:

Suppose Person A e-mails Person B. The e-mail contains 1 Excel workbook, along with a pdf and a Word document.

When Person B receives the e-mail, they can:


Accept (in which case the e-mail along with all THREE attachments are forwarded to Person C).

Reject (in which case the e-mail along with all THREE attachments are returned to Person A).


Can all of the above be done with just Excel using VBA or must some VBA be added to Person A / B's Outlook or perhaps even utilising Rules in Outlook?


Thanks

 

[RoryA]

Where exactly would the controlling Excel workbook be?

 

[tiredofit]

Person A has it saved in his C drive.

If it's only the controlling Excel workbook that needs to "travel", I've already done that using just VBA in Excel.

The difficulty lies in the additional attachments.

 

[RoryA]

The workbook would have to be open and already running on the relevant machine when the email arrived.

 

[tiredofit]

Let's assume that will be the case.

So far, my code to attach itself (ie the controlling workbook) is as follows:

objMail.Attachments.Add ThisWorkbook.FullName

so how can I attach the other two attachments (pdf and word doc) as well?

 

[RoryA]

Just repeat that line and specify the full path and file name for each attachment.

 

[tiredofit]

Correct me if I'm wrong but doesn't that involve Person B saving all three attachments when he receives the e-mail, then attaching them again?


At the moment what I have already done is when Person B receives the e-mail (containing ONLY the controlling workbook), he opens the attachment, which contains a button (with VBA behind) to Accept or Reject.


If Reject, an e-mail is automatically sent back to Person A, along with the workbook.

If Accept, an e-mail is automatically sent to Person C, with the workbook.


Nobody has to ever manually attach attachments (admittedly it's the scenario where only a single workbook is attached).

 

[tiredofit]

Perhaps a workaround would be when Person B receives the e-mail (containing the 3 attachments, controlling wb plus pdf and word), he opens the wb, clicks the button, which somehow saves the 3 attachments in the currently opened e-mail.

That way it can attach it later.