add reminder flag to email item via excel vba

**kuraitori** · 08-11-2009, 05:40 PM

Hello All,

I am experimenting with generating emails from and excel form.

default mail program is outlook. what I want to do is add a follow-up flag to the email that has a due-date of two days past the current date

here is the send mail method i use

Please Login or Register  to view this content.

I tried this method with the "With olEmail" portion. But it didn't work

Please Login or Register  to view this content.

also, if you know of a list of other properties of outlook emails that can be set via vba, that would just be...killer.

**DonkeyOte** · 08-12-2009, 02:51 AM

Perhaps:

Please Login or Register  to view this content.

As for working out what's available and what isn't - it's generally advised to use early binding initially such that you have reference to the Object Library, once complete then revert code to late binding, or if preferred simply go into the VBE in OL and use the Object Browser there
(ie view MailItem to see properties thereof)

**[email protected]** · 03-20-2013, 03:46 PM

Hi,

I am trying to set follow up flag for recepient and for me. But it not working.. Any suggestions are wecome.

Please Login or Register  to view this content.

**arlu1201** · 03-21-2013, 09:58 AM

rglucknow,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Also,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.