ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit and forward mails (https://www.excelbanter.com/excel-programming/391923-edit-forward-mails.html)

navin

edit and forward mails
 
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


steve_doc

edit and forward mails
 
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




All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com