-
Oct 7th, 2014, 12:02 PM
#1
Thread Starter
Lively Member
-
Oct 7th, 2014, 12:04 PM
#2
Thread Starter
Lively Member
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
Also, if you have any alternate ways of writing this code which would simplify it, I'd welcome the learning experience. I know there has to be an easier way, this was the only way I could get it to work for me at the time. #StillLearning
-
Oct 7th, 2014, 03:32 PM
#3
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
try
Code:
.importance = olImportanceHigh
.OriginatorDeliveryReportRequested = True
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Oct 8th, 2014, 11:28 AM
#4
Thread Starter
Lively Member
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
thank you, it works perfectly. I had tried to make the .Importance = True ... would be nice if that would work as well, I wouldn't have known otherwise, but I know now.
Do you know of any particular resources that teach these commands? Even just the most basic or to provide a clear understanding of the framework of VBA? I'm learning, but it feels like I'm learning it the hard way all the time.
-
Oct 8th, 2014, 03:23 PM
#5
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
but it feels like I'm learning it the hard way all the time.
lol
most of the information is in the vba help file, that is where i looked the value
else google
unfortunately, as there are multi values for importance, vba true = -1, is not one of them, false = 0 may well work, but not give the desired result to turn off
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Oct 8th, 2014, 05:22 PM
#6
Thread Starter
Lively Member
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
Originally Posted by westconn1
lol
most of the information is in the vba help file...
Where is this VBA help file... why do I feel like Corky right now... This information might save me a lot of trouble.
-
Oct 9th, 2014, 02:50 AM
#7
Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.
Where is this VBA help file
on the CD
silly as it may seem the VBA help file is an optional install when installing office
i always do a custom install so i can select VBA help and deselect the stupid office assistant (paperclip)
F1 on any object property or method should bring up context help
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|