Hello,
I have attached a macro which sends mail through outlook. I wanted to tweak this macro a lil bit.
I want to have different subjects below one another, and the user should have an option which should mail should be sent during that time. For ex : If i want to send for missing date - I will select either Yes or Y besides that template and run the macro.
With this current macro, I am unable to do so. Please can anyone help me with this. ! Thanks a lot in advance.
Something like this:Instead of .subject =
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
It is not working when i amended the macro. Can you please amend the macro and send me? I think I am missing something when am amending it. Thanks.
Please Login or Register to view this content.
Working awesome....But I would need some more tweaks..
I need the macro to work for 8 different scenarios...1) Date missing 2) Time missing 3) Date & Order code missing 4) Date & Time missing 5) Date, Time and Consignee missing 6) Order code missing 7) Time & Order code missing.
Also I want this macro to be implemented for 7 worksheets. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks