View Single Post
  #1  
Old December 19th 14, 08:20 PM
Philip Rose Philip Rose is offline
Junior Member
 
First recorded activity at Outlookbanter: Dec 2014
Location: Manchester, UK
Posts: 1
Question Acquiring selected email to work with in VBA

I am really quite embarrassed at the gaps in my knowledge and with this being my first time post I hope you can direct me to the right place if posting this question here is inappropriate.

I have done a moderate amount of VBA programming with Access and have manipulated.OFT files to adjust their content and send them. I now wish to be able to do similar work on incoming emails but I really don't know where to begin! I suppose I'm asking…

1: how do I capture the currently selected email in a mail folder?

2: When I have it what are the accessible variables for the various components of the email including the body text of the email itself?

3: When I have manipulated these variables how do I save the email and move it to a different mail folder?

I know that much of this could be done using a macro rather than VB code but I don't know how to create a macro either!

Perhaps you could point me to a (simple!) Help document or possibly point me towards code for a module that does similar things.

I will be so grateful for your help and thank you in advance.

Philip

UPDATE: After stumbling about this and other forums, I have managed to work out and largely solve most of the questions above and managed to produce a successful macro. However further guidance would not only be useful for me but I guess it might be for others too. For this reason I have left this thread open.

Last edited by Philip Rose : January 1st 15 at 12:18 PM. Reason: UPDATE
Ads