Capture the subject line of an e-mail

30 Dec 2004 5:27 PM

Wayne

Forgive me if this question seems basic. I have very little experience in
writing Macros in Outlook.

I am looking to write a macro that saves the file attachment contained in
the e-mail as the subject line of the e-mail, however I do not know the
syntax of capturing the text of the subject line of the e-mail. Any help
would be greatly appreciated.

Platform: Windows XP / Outlook XP

30 Dec 2004 8:31 PM

Michael Bauer

Hi Wayne,

you can use several functions, e.g.:

1) Left$, for the left part of the subject,
2) Right$, for the right part,
3) InStr, for a string contained anywhere in the subject.

The first and second are case-sensitive. For the third function you can
choose by the last parameter: vbBinaryCompare is case-sensitive,
vbTextCompare case-insensitive.

--
Viele GrÃ¼ÃŸe
Michael Bauer

Show quoteHide quote

"Wayne" <Wa***@discussions.microsoft.com> wrote in message
news:AEE9C712-1978-4EB0-98A4-5D000FA48AE3@microsoft.com...
> Forgive me if this question seems basic. I have very little
experience in
> writing Macros in Outlook.
>
> I am looking to write a macro that saves the file attachment contained
in
> the e-mail as the subject line of the e-mail, however I do not know
the
> syntax of capturing the text of the subject line of the e-mail. Any
help
> would be greatly appreciated.
>
> Platform: Windows XP / Outlook XP
>
>