V6.1 - Email Notifications

Thanks!!! That worked!

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Tuesday, July 12, 2005 11:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V6.1 - Email Notifications


Triggering the following (replacing {email address} with your chosen
address) using only the part.inactive field.
If this is not exactly what you need it should be close enough to get
you
there.
Good luck,
Aaron Hoyt
Vantage Plastics

/* Include file for access to global alerts */
{ud/GlbAlert.i &tablename = "Part" }

/* Define Variables */
DEFINE VARIABLE NewEmailBofy AS CHARACTER NO-UNDO.

/* If the Part was not previously inactive cancel, otherwise send email
*/
IF OldPart.Inactive <> True
THEN DO:
Return "Cancel Send":U.
END.
ELSE DO:

ASSIGN Email-To = "{email address}"
Email-Subject = "Part Reactivated"
Email-Text = "Part "
+ string(Part.PartNumber)
+ " has been changed from Inactive to Active.".

END.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michelle de la Vega
Sent: Tuesday, July 12, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1 - Email Notifications


I am trying to write a .p file that only sends an email when the
part.inactive field changes from True to False.

How can I write this?

Any suggestions would be greatly appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
I am trying to write a .p file that only sends an email when the
part.inactive field changes from True to False.

How can I write this?

Any suggestions would be greatly appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[Non-text portions of this message have been removed]
Michelle,

Below is the script I use, however you will get new parts added also.
Modify to suit your own preferences.

Patrick Winter
Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



/* Program to send a global alert on Reopening a Part
or Inactivating a Part
by Patrick Winter 10/15/2004 */
{ud/GlbAlert.i &TableName = "Part"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF Part.Inactive = FALSE
THEN DO:
ASSIGN Email-Subject = Part.PartNum + " reopened or new part by " +
USERID.
ASSIGN Email-Text = "Part was reopened.".
END.
ELSE DO:
ASSIGN Email-Subject = Part.PartNum + " inactivated by " + USERID.
ASSIGN Email-Text = "Part was inactivated. sSc MPN: " +
Part.Searchword.
END.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Tuesday, July 12, 2005 9:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1 - Email Notifications

I am trying to write a .p file that only sends an email when the
part.inactive field changes from True to False.

How can I write this?

Any suggestions would be greatly appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Triggering the following (replacing {email address} with your chosen
address) using only the part.inactive field.
If this is not exactly what you need it should be close enough to get you
there.
Good luck,
Aaron Hoyt
Vantage Plastics

/* Include file for access to global alerts */
{ud/GlbAlert.i &tablename = "Part" }

/* Define Variables */
DEFINE VARIABLE NewEmailBofy AS CHARACTER NO-UNDO.

/* If the Part was not previously inactive cancel, otherwise send email */
IF OldPart.Inactive <> True
THEN DO:
Return "Cancel Send":U.
END.
ELSE DO:

ASSIGN Email-To = "{email address}"
Email-Subject = "Part Reactivated"
Email-Text = "Part "
+ string(Part.PartNumber)
+ " has been changed from Inactive to Active.".

END.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michelle de la Vega
Sent: Tuesday, July 12, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1 - Email Notifications


I am trying to write a .p file that only sends an email when the
part.inactive field changes from True to False.

How can I write this?

Any suggestions would be greatly appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links