View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
navin navin is offline
external usenet poster
 
Posts: 32
Default edit and Forward email

Hi All,

I receive some 100 mail daily on the PO which has been placed with
different supplier. once i receive these emails of PO copy i forward
the mail to the respective suppliers.

the macro i wrote successfully forwards the email item which i have
received. However, i would like to edit the mail before its been
forwarded to the suppliers and this is what i dont understand how to
do it.

I am using the below code for forwarding the mails:

Set myinspector = olMi.GetInspector
Set olMi1 = myinspector.CurrentItem.Forward
olMi1.Display
olMi1.Recipients.Add vndrEMAIL
olMi1.Send

Please help me.

Thanks in advance.
Navin