LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default Sending Emails

I have the following Excel with data in columns:

State-Name-Customer-Email-PO-NV-Product01-Qty01-Product02-Qty02-Product03-Qty03-DeliveryDate

And I would like to create a code that everytime the user enters the last
info on Delivery Date, it sends and automated email to the Email stated on
that row,
So the email would use the information stored on the rows:

Subject: (State) (PO) (Customer)
Message:
Dear (Name):
Your Purchase Order (PO) associated to our Nota de Venta(NV) with the
following products:
(Product01) (Qty01)
(Product02) (Qty02)
(Product03) (Qty03)

is under production and it will be ready for delivery on (DeliveryDate).

Best regards. Bla bla

Thank You!
 
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
Trouble Sending emails Michelle Excel Programming 3 June 13th 08 04:45 PM
Sending emails from worksheet Nick Wakeham Excel Discussion (Misc queries) 1 June 28th 06 04:57 PM
Help Sending Emails From Excel mrk0 Excel Discussion (Misc queries) 1 July 6th 05 06:42 PM
Sending emails from Excel David Robinson[_2_] Excel Programming 1 September 21st 03 08:40 AM


All times are GMT +1. The time now is 08:29 AM.

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

About Us

"It's about Microsoft Excel"