Email reply / generate excel file

[fergo99]

Currently each email I receive is assigned a task number in another system. I need to create I need to create something that will allow me to enter the number assigned in a form, do a reply to all recipients of the email deleting the address that the email was sent to and CC another email to each reply. This reply needs to report the number assigned to the email. I also need this to copy the entire email to a excel file and place it in a specific folder. Do anyone have any suggestions on this.

[Demosthine]

Good Evening Fergo.

I was browsing though messages that have 0 posts and found yours from, well, a very long time ago. If you still have this problem, let me know. I've done a good amount of cross-application data exchange and should definitely be able to help with this.

Scott

[tuxy]

Good Evening Fergo.

I was browsing though messages that have 0 posts and found yours from, well, a very long time ago. If you still have this problem, let me know. I've done a good amount of cross-application data exchange and should definitely be able to help with this.

Scott

I have the following problem : a list of records containing data field such as item code number , qty to be delivered etc....the last record is the customer e_mail account where I need to forward the previous info, the question is : is it possible to perform this task using VBA? (see example attached) :think:

[Demosthine]

Hey there.

Unfortunately, I've very sorry this hasn't been answered long before now. But on the positive side of the coin, my answer is yes, this is very possible.

The key to this program is interfacing with the Mail Server. I would like to refer you to this thread which has some discussion regarding a SendMail Function that my partner and I wrote. It uses Collaborative Data Objects (CDO) and is set up in a very simple function where you pass it variables that you will should know the answer to.

The Document attached to my final message in the other thread should give you an excellent starting point, as composing and sending the email is the most difficult portion of your project.

Now, how much programming experience do you have in VBA? Are you starting out from complete scratch where you needed guided through the entire process or is what I've referenced you to enough of a start? I am more than willing to help if you need it.

Good luck and let me know how things go.
Scott

[tuxy]

Hey there.

Unfortunately, I've very sorry this hasn't been answered long before now. But on the positive side of the coin, my answer is yes, this is very possible.

The key to this program is interfacing with the Mail Server. I would like to refer you to this thread which has some discussion regarding a SendMail Function that my partner and I wrote. It uses Collaborative Data Objects (CDO) and is set up in a very simple function where you pass it variables that you will should know the answer to.

The Document attached to my final message in the other thread should give you an excellent starting point, as composing and sending the email is the most difficult portion of your project.

Now, how much programming experience do you have in VBA? Are you starting out from complete scratch where you needed guided through the entire process or is what I've referenced you to enough of a start? I am more than willing to help if you need it.

Good luck and let me know how things go.
Scott
Thank you for your prompt reply , I have tested the code posted by Xld at the following link :

http://vbaexpress.com/forum/showthread.php?t=21633
It works , but I need to send the entire report (see the two differend coloured areas) once to the e_mail reported in column "O" (see file attached).
In other words the macro should see the e_mail and send to that account all the coloured area. I tried to modify the code but without success.