Hi All ,
Would like to ask for a macros to email a specific row with header based on due date with it's corresponding email. The macros can still work with some newly added rows ,since the summary is to be updated by me every now and then. Please see attached file for reference .Hopefully you can help me.
Love lots ! and Godbless !
Last edited by mscarrie; 07-30-2019 at 04:02 AM.
anyone ? please help me
Your requirement is very vague...Does not explain what you want done...Would like to ask for a macros to email a specific row with header based on due date with it's corresponding email
Give a step by step explanation of what the code must do then someone will be able to assist...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
oh sorry for this sintek , what i want to do is as i put a due date in H column ,it will email the specific row from A to G ,and to always include the top row for reference. The function that i want is like an email reminder in Google Sheets .I want that kind of function to my excel since internet here was not that stable and my boss was too old to use Google Sheets. Thanks ,i have included an attachment for this .
H2 as per your attachment has an email address in...As previously mentioned...
.Give a step by step explanation of what the code must do then someone will be able to assist..
yes that was my testing email .since there are different emails( email of the agent) in H column ,depending on their clients in Column E .
i haven't encode them yet.
You are not being forthcoming with your requirement and not answering directly...Not prepared to assist if you cannot clarify step by step what you require...
I don't get it
Last edited by AliGW; 07-30-2019 at 04:01 AM. Reason: Original text of message reinstated.
You have been asked, more than once, to do this:
Please do so. The information you have given so far is not detailed enough for anyone to be able to help you.Give a step by step explanation of what the code must do.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I don't get it
First , i put a date in Column H.
Second , it will email all the datas in that row ,in the email listed in Column G .
That's the process itself
Like this ? is this the step by step ? huhuhuhu
With an attitude like that, you will be lucky to get any help at all.
You are here for help: if you make condescending comments to those trying to help you, they will probably decide not to bother. Mind your manners, please.
okay
Column H? Are you sure?First , i put a date in Column H.
Second , it will email all the datas in that row ,in the email listed in Column G .
That's the process itself
If you can't even be bothered to check what you have written, what hope do we have of helping you?
Really...No need to be cheeky...Like this ? is this the step by step ? huhuhuhu
You do not have an email list in column G...
So what you are saying...When you enter any date into any row of Column H, then only that row with the header row must be added to an email as an attachment and sent to this imaginary email address in Column G...
EDIT
And also...Please do not edit posts after we have commented...As that just makes us look stupid...
I have reversed the post-editing. Don't do that again, please.
ooohhh sorry i thought if adding the step by step process someone would help me
Yes there was no email as of now .but i will add it as soon as there was a VBA for emailing the details .
Duly noted. ThanksOriginally Posted by AliGW
I gave you a breakdown enquiring if that is what you wanted...Please upload a sample file with correct setup...Yes there was no email as of now .but i will add it as soon as there was a VBA for emailing the details .
As I now understand it...
According to your upload...Date is in column I...Email in Column H
Please Login or Register to view this content.
Code works as follows...When entering a date in any row of Column I the code attaches a copy of Row 1 A to H and Active Row A to H and emails it as an attachment...
Last edited by sintek; 07-30-2019 at 04:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks