How To Make a Reply Email Instead of A New Email Subject With VBA
Hi everyone,
I face a problem when I try to make an email reply using vba. My vba code send an email into a new conversation instead of reply to an existing subject.
Here is my code.
Please Login or Register to view this content.
How to change it so that it send an email in reply email instead of create a new email?
The reply subject is "SPARE PART TO CHECK" that already in the email
What is the email you are replying to?
With the code, I send an email with the subject "SPARE PART TO CHECK"
In the next email, I don't want to send an email with the same subject, but I want the code to reply the "SPARE PART TO CHECK" subject Email.
You need to give a better explanation of your overall problem. Are you using the same code to send the next email? How will you indicate which email to reply to? (Why do you want to "reply" to an email that you sent yourself?)
In my current code, I use it to deliver an email with the content is a list of spare part that need to monitored and sent it to another people. Now, they want the spare part stock list sent inside the email that I already delivered (reply my own email) so that they can check what change in the spare part monitoring list faster (only scrolling the reply). That's why I want to change it into auto-reply email into an already create subject email instead of sending a new email everyday with the same subject (but not a reply email).
I kind of bad at explaining things, so if there is something that still not clear, please ask again.
It is possible to find an email in your own "Sent Items" folder and reply to it, but you have to have a way of identifying which email you want to reply to. What are the unique identifiers of that email?
You said you want to change this code. But it seems to me that you have to have one Sub to create a new email, and a different one that sends a reply to one that you already sent. How do you decide when you need a new one?
The unique identifiers is the subject is "SPARE PART TO CHECK"
I already create the email with the subject "SPARE PART TO CHECK". After that, I dont want to create an auto generate email using subject "SPARE PART TO CHECK", but I want to reply to the subject "SPARE PART TO CHECK" email. So, I want to change the code into replying an email with "SPARE PART TO CHECK" subject, not creating a new email.
So once you create an email with a subject SPARE PART TO CHECK, you will never use that subject again?
Yes, that's true
But it's hard-coded into your code. That means you only run the code once? Sorry, but I still find your basic idea of what you want to do confusing.
Is there only one single email that you created, and now you want subsequent emails to reply to that one email?
Well here is my idea.
I already sent an email with spare part list to other people email, and from now I want to reply my own email so that the other people that I sent the email to can track the changes in the spare part list easier. If I sent another new email, it will be harder to track the changes in my spare part list because other people have to search one by one my sent email. That's why I want to reply my own email.
And yes, there is only one single email that I created, and I want to reply my own email so that other people can track the changes in the spare part list day by day easier. Is that possible?
Sorry for late response
That clears up what you want to do. I will have to look into how to find the email to reply to. It's not hard, I just don't have it in my head.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks