R
Richard Conway
Hi there, I carry out a process every day that takes me ages and I'm sure I
can automate at least part of it. I've never really delved into Macros in
the past but am generally pretty decent at coding and have used VB quite a
bit. I just want some general feedback and ideas about weather what I want
to do is possible and a guidance on how it would be done.
The steps required would be as follows:
- Go through messages in an Outlook folder one at a time
- check each message and see if it has a word attachment
- if it has, open the word document, then copy the body text of the email
and paste it as a new page at the start of the word document.
- Save the word document
- Close the word document
- Move the original mail message into a different mail folder
Any hints, tips, suggestions much appreciated.
Thanks,
Richard.
can automate at least part of it. I've never really delved into Macros in
the past but am generally pretty decent at coding and have used VB quite a
bit. I just want some general feedback and ideas about weather what I want
to do is possible and a guidance on how it would be done.
The steps required would be as follows:
- Go through messages in an Outlook folder one at a time
- check each message and see if it has a word attachment
- if it has, open the word document, then copy the body text of the email
and paste it as a new page at the start of the word document.
- Save the word document
- Close the word document
- Move the original mail message into a different mail folder
Any hints, tips, suggestions much appreciated.
Thanks,
Richard.