Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Coma between two e-mails Hemang Excel Discussion (Misc queries) 3 May 13th 10 10:30 PM
brought forward & carried forward Sudipta Sen[_2_] Excel Worksheet Functions 1 November 22nd 09 09:09 AM
Finding e-mails James Excel Worksheet Functions 0 February 11th 09 11:15 AM
send e-mails bra863 Excel Discussion (Misc queries) 1 August 22nd 08 04:28 PM
edit and Forward email navin Excel Programming 0 June 19th 07 09:03 AM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"