Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I receive some 50 mails daily with copy of POs placed and then these mails are forwarded to the respective suppliers. I am able to forward the mails by using inspector method. However, one of the requirement is to edit the body of the mail with "Please find attached the PO" and then forward the mail. Any help and suggestion would be appreciated. Thanks in advance, Navin |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Navin
I work with a similar system system on a daily basis This is my approach - I am sure there are others 1. Extract Emails to excel for a given date, fields are set to columns, ie To, From , Subject, Body etc 2. preform certain tasks in excel - then mail the results to various parties. the following websites will give you the basis of the extraction methods Lotus Notes - http://www.excelkb.com/?cNode=1X5M7A Outlook - http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q HTH "navin" wrote: Hi, I receive some 50 mails daily with copy of POs placed and then these mails are forwarded to the respective suppliers. I am able to forward the mails by using inspector method. However, one of the requirement is to edit the body of the mail with "Please find attached the PO" and then forward the mail. Any help and suggestion would be appreciated. Thanks in advance, Navin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Coma between two e-mails | Excel Discussion (Misc queries) | |||
brought forward & carried forward | Excel Worksheet Functions | |||
Finding e-mails | Excel Worksheet Functions | |||
send e-mails | Excel Discussion (Misc queries) | |||
edit and Forward email | Excel Programming |