BPM for sending email

Go to your SMTP connector and pull up the properties. There is a tab that
has sending and receiving policies. Click on the button for sending
policies. There you can give it a single IP address among other options.

Mark W.
On Oct 13, 2010 11:55 AM, <effgroups@...> wrote:
> Thanks Jared.
>
> But we have exchange 2003.
> Do you know how to allow it there ?
> Ephraim
> Ephraim Feldman
>
> -----Original Message-----
> From: "k99ja04" <jallmond@...>
> Sender: vantage@yahoogroups.com
> Date: Wed, 13 Oct 2010 02:52:24
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM for sending email
>
> Ephraim,
>
> In Exchange 2007+ you can either modify the default receive connector to
accept anonymous connections (be careful here!), or I recommend making a
specific receive connector that does allow anonymous, but only from the IP
address of your Vantage server.
>
> Cheers,
> Jared
>
> --- In vantage@yahoogroups.com, effgroups@... wrote:
>>
>> Yes I'm running exchange.
>> But interestingly the BAM does send out emails without a problem.
>>
>> I will ask our server IT to give permission. Do you know what he has to
change?
>>
>> Ephraim
>> Ephraim Feldman
>
>
>
>
>
> [Non-text portions of this message have been removed]
>


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

I want to create a BPM to send a email when a date in the order entry is changed.

I want the email should be from the person doing the change to the person that entered the order.

The problem is that altough i can get the userid of the user doing the change and the order entry person but how do i get their email address.
the email address is in the user file but this is not part of the tables available when doing the BPM.

please if someone could help me out on this

Ephraim
This isn't from one of my BPM's but a BAM alert, but its 4gl none the
less, it should give you an idea.. You can make an independent query to
any table, fill in the variables as required. Substitute user id for
empID



Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.

If available EmpBasic Then Do:

If Active = Yes and EmpBasic.JCDept = "EQUIP" and LaborDtl.IndirectCode
= "MNT" Then Do:

DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.

Assign EquipID = EmpBasic.FirstName.

Assign Email = EmpBasic.EMailAddress.



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of efyf_1999
Sent: Thursday, October 07, 2010 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM for sending email





Hi all

I want to create a BPM to send a email when a date in the order entry is
changed.

I want the email should be from the person doing the change to the
person that entered the order.

The problem is that altough i can get the userid of the user doing the
change and the order entry person but how do i get their email address.
the email address is in the user file but this is not part of the tables
available when doing the BPM.

please if someone could help me out on this

Ephraim





[Non-text portions of this message have been removed]
Thanks Rob for your quick reply

i know i can get it with some GL code but in the template provided for sending email from BPM i can only select from the ttfields and not put code there.

Ephraim

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> This isn't from one of my BPM's but a BAM alert, but its 4gl none the
> less, it should give you an idea.. You can make an independent query to
> any table, fill in the variables as required. Substitute user id for
> empID
>
>
>
> Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
> LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.
>
> If available EmpBasic Then Do:
>
> If Active = Yes and EmpBasic.JCDept = "EQUIP" and LaborDtl.IndirectCode
> = "MNT" Then Do:
>
> DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.
>
> Assign EquipID = EmpBasic.FirstName.
>
> Assign Email = EmpBasic.EMailAddress.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of efyf_1999
> Sent: Thursday, October 07, 2010 11:36 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BPM for sending email
>
>
>
>
>
> Hi all
>
> I want to create a BPM to send a email when a date in the order entry is
> changed.
>
> I want the email should be from the person doing the change to the
> person that entered the order.
>
> The problem is that altough i can get the userid of the user doing the
> change and the order entry person but how do i get their email address.
> the email address is in the user file but this is not part of the tables
> available when doing the BPM.
>
> please if someone could help me out on this
>
> Ephraim
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
That is correct, perhaps I misread your intent. In the standard 'wizard
templates' if you will, only the tables associated with the current
dataset transaction are eligible.



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of efyf_1999
Sent: Thursday, October 07, 2010 12:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email





Thanks Rob for your quick reply

i know i can get it with some GL code but in the template provided for
sending email from BPM i can only select from the ttfields and not put
code there.

Ephraim

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> This isn't from one of my BPM's but a BAM alert, but its 4gl none the
> less, it should give you an idea.. You can make an independent query
to
> any table, fill in the variables as required. Substitute user id for
> empID
>
>
>
> Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
> LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.
>
> If available EmpBasic Then Do:
>
> If Active = Yes and EmpBasic.JCDept = "EQUIP" and
LaborDtl.IndirectCode
> = "MNT" Then Do:
>
> DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.
>
> Assign EquipID = EmpBasic.FirstName.
>
> Assign Email = EmpBasic.EMailAddress.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of efyf_1999
> Sent: Thursday, October 07, 2010 11:36 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BPM for sending email
>
>
>
>
>
> Hi all
>
> I want to create a BPM to send a email when a date in the order entry
is
> changed.
>
> I want the email should be from the person doing the change to the
> person that entered the order.
>
> The problem is that altough i can get the userid of the user doing the
> change and the order entry person but how do i get their email
address.
> the email address is in the user file but this is not part of the
tables
> available when doing the BPM.
>
> please if someone could help me out on this
>
> Ephraim
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
So what will be the best way to accomplish what i want ?



--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> That is correct, perhaps I misread your intent. In the standard 'wizard
> templates' if you will, only the tables associated with the current
> dataset transaction are eligible.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of efyf_1999
> Sent: Thursday, October 07, 2010 12:26 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM for sending email
>
>
>
>
>
> Thanks Rob for your quick reply
>
> i know i can get it with some GL code but in the template provided for
> sending email from BPM i can only select from the ttfields and not put
> code there.
>
> Ephraim
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
> Bucek" <rbucek@> wrote:
> >
> > This isn't from one of my BPM's but a BAM alert, but its 4gl none the
> > less, it should give you an idea.. You can make an independent query
> to
> > any table, fill in the variables as required. Substitute user id for
> > empID
> >
> >
> >
> > Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
> > LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.
> >
> > If available EmpBasic Then Do:
> >
> > If Active = Yes and EmpBasic.JCDept = "EQUIP" and
> LaborDtl.IndirectCode
> > = "MNT" Then Do:
> >
> > DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.
> >
> > Assign EquipID = EmpBasic.FirstName.
> >
> > Assign Email = EmpBasic.EMailAddress.
> >
> >
> >
> > Rob Bucek
> >
> > Production Control Manager
> >
> > PH: (715) 284-5376 ext 311
> >
> > Mobile: (715)896-0590
> >
> > FAX: (715)284-4084
> >
> > <http://www.dsmfg.com/>
> >
> > (Click the logo to view our site) <http://www.dsmfg.com/>
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of efyf_1999
> > Sent: Thursday, October 07, 2010 11:36 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] BPM for sending email
> >
> >
> >
> >
> >
> > Hi all
> >
> > I want to create a BPM to send a email when a date in the order entry
> is
> > changed.
> >
> > I want the email should be from the person doing the change to the
> > person that entered the order.
> >
> > The problem is that altough i can get the userid of the user doing the
> > change and the order entry person but how do i get their email
> address.
> > the email address is in the user file but this is not part of the
> tables
> > available when doing the BPM.
> >
> > please if someone could help me out on this
> >
> > Ephraim
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I use the following code in a BPM to send an email to the Entry Person on a
Sales Order when a Shop Floor Employees marks an ART SETUP operation we have
complete.

HTH

Scott

----------------------------------------------------------------------------
--

repeat:
define variable vFrom as character no-undo initial '':U.
define variable vTo as character no-undo initial '':U.
define variable vCC as character no-undo initial '':U.
define variable vSubject as character no-undo initial '':U.
define variable vBody as character no-undo initial '':U.
define variable hEmailEx as handle no-undo.

run Bpm/BpmEmail.p persistent set hEmailEx.
define variable from_cnt as integer no-undo.
assign vFrom = 'vantage@...'.

define variable to_cnt as integer no-undo.

define variable cc_cnt as integer no-undo.
assign vCC = ''.

define variable subject_cnt as integer no-undo.

define variable body_cnt as integer no-undo.

for each LaborDtl where (ttLaborDtl.JobNum = LaborDtl.JobNum AND
ttLaborDtl.ClockInDate = TODAY + 0) no-lock , each JobProd where
(ttLaborDtl.Company = JobProd.Company and ttLaborDtl.JobNum =
JobProd.JobNum) no-lock , each OrderHed where (JobProd.Company =
OrderHed.Company and JobProd.OrderNum = OrderHed.OrderNum) no-lock , each
JobHead where (ttLaborDtl.Company = JobHead.Company and ttLaborDtl.JobNum =
JobHead.JobNum) no-lock , each UserFile where (OrderHed.Company =
Userfile.CurComp and OrderHed.EntryPerson = UserFile.DcdUserID) no-lock:

assign vTo = UserFile.EMailAddress.
assign vSubject = 'ART SETUP COMPLETE - ' +
STRING(ttLaborDtl.JobNum).
assign vBody = "Job Number: " + STRING(ttLaborDtl.JobNum) + CHR(10)
+ "Job Name: " + JobHead.ShortChar01.

end.

for each LaborDtl where (ttLaborDtl.JobNum = LaborDtl.JobNum) no-lock , each
JobOper where ( JobOper.OpCode = 'ARTAPROV') and (ttLaborDtl.Company =
JobOper.Company and ttLaborDtl.JobNum = JobOper.JobNum) no-lock .

assign vBody = vBody + CHR(10) + "Art Aprroval Due Date: " +
STRING(JobOper.DueDate).

end.

run SendEmail in hEmailEx (
false,
CUR-COMP,
vFrom,
vTo,
vCC,
vSubject,
vBody,
"":U
).
/* async as logical
company as character
emailFrom as character
emailTo as character
emailCC as character
emailSubject as character
emailText as character
emailMimeHeader as character */
IF valid-handle(hEmailEx) THEN delete procedure hEmailEx.
leave.
END.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
efyf_1999
Sent: Thursday, October 07, 2010 1:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email

So what will be the best way to accomplish what i want ?



--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> That is correct, perhaps I misread your intent. In the standard
> 'wizard templates' if you will, only the tables associated with the
> current dataset transaction are eligible.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of efyf_1999
> Sent: Thursday, October 07, 2010 12:26 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM for sending email
>
>
>
>
>
> Thanks Rob for your quick reply
>
> i know i can get it with some GL code but in the template provided for
> sending email from BPM i can only select from the ttfields and not put
> code there.
>
> Ephraim
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Rob Bucek" <rbucek@> wrote:
> >
> > This isn't from one of my BPM's but a BAM alert, but its 4gl none
> > the less, it should give you an idea.. You can make an independent
> > query
> to
> > any table, fill in the variables as required. Substitute user id for
> > empID
> >
> >
> >
> > Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
> > LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.
> >
> > If available EmpBasic Then Do:
> >
> > If Active = Yes and EmpBasic.JCDept = "EQUIP" and
> LaborDtl.IndirectCode
> > = "MNT" Then Do:
> >
> > DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.
> >
> > Assign EquipID = EmpBasic.FirstName.
> >
> > Assign Email = EmpBasic.EMailAddress.
> >
> >
> >
> > Rob Bucek
> >
> > Production Control Manager
> >
> > PH: (715) 284-5376 ext 311
> >
> > Mobile: (715)896-0590
> >
> > FAX: (715)284-4084
> >
> > <http://www.dsmfg.com/>
> >
> > (Click the logo to view our site) <http://www.dsmfg.com/>
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> On Behalf
> > Of efyf_1999
> > Sent: Thursday, October 07, 2010 11:36 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] BPM for sending email
> >
> >
> >
> >
> >
> > Hi all
> >
> > I want to create a BPM to send a email when a date in the order
> > entry
> is
> > changed.
> >
> > I want the email should be from the person doing the change to the
> > person that entered the order.
> >
> > The problem is that altough i can get the userid of the user doing
> > the change and the order entry person but how do i get their email
> address.
> > the email address is in the user file but this is not part of the
> tables
> > available when doing the BPM.
> >
> > please if someone could help me out on this
> >
> > Ephraim
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [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/linksYahoo! Groups Links
Here's a way that will work...but only if you have Epicor Service Connect developer edition handy. You create a BAQ with the output info you need to include, and set up an "export query output" scheduled to run in Vantage say, every morning at 6 AM. You output this .csv file to a specific folder where it is pickud up, and enters a simple ESC workflow that sends an email to the email address variable you have set, with the information in your BAQ output. You can create emails with any information you can produce using a BAQ.
I posted some code for a similar issue here.

http://tech.groups.yahoo.com/group/vantage/message/93590

With what Scott posted that should get you going.
Cheers,
Jared

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> I use the following code in a BPM to send an email to the Entry Person on a
> Sales Order when a Shop Floor Employees marks an ART SETUP operation we have
> complete.
>
> HTH
>
> Scott
Rob,
 'Production Control Manager'? Wow. SOMEBODY got a nice promotion at the end of
July. Just noticing.

Congratulations. Well deserved.

-Karl


________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Thu, October 7, 2010 10:44:19 AM
Subject: RE: [Vantage] Re: BPM for sending email

Â
That is correct, perhaps I misread your intent. In the standard 'wizard
templates' if you will, only the tables associated with the current
dataset transaction are eligible.

Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of efyf_1999
Sent: Thursday, October 07, 2010 12:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email

Thanks Rob for your quick reply

i know i can get it with some GL code but in the template provided for
sending email from BPM i can only select from the ttfields and not put
code there.

Ephraim

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> This isn't from one of my BPM's but a BAM alert, but its 4gl none the
> less, it should give you an idea.. You can make an independent query
to
> any table, fill in the variables as required. Substitute user id for
> empID
>
>
>
> Find EmpBasic where LaborDtl.Company = EmpBasic.Company and
> LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock.
>
> If available EmpBasic Then Do:
>
> If Active = Yes and EmpBasic.JCDept = "EQUIP" and
LaborDtl.IndirectCode
> = "MNT" Then Do:
>
> DEFINE VARIABLE EquipId AS CHARACTER NO-UNDO.
>
> Assign EquipID = EmpBasic.FirstName.
>
> Assign Email = EmpBasic.EMailAddress.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of efyf_1999
> Sent: Thursday, October 07, 2010 11:36 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BPM for sending email
>
>
>
>
>
> Hi all
>
> I want to create a BPM to send a email when a date in the order entry
is
> changed.
>
> I want the email should be from the person doing the change to the
> person that entered the order.
>
> The problem is that altough i can get the userid of the user doing the
> change and the order entry person but how do i get their email
address.
> the email address is in the user file but this is not part of the
tables
> available when doing the BPM.
>
> please if someone could help me out on this
>
> Ephraim
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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







[Non-text portions of this message have been removed]
Thanks for all
I will try jared and scott suggestion tomorrow.
I don't have the service connect so I cant try that.

Ephraim
Ephraim Feldman

-----Original Message-----
From: "k99ja04" <jallmond@...>
Sender: vantage@yahoogroups.com
Date: Thu, 07 Oct 2010 21:53:33
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email

I posted some code for a similar issue here.

http://tech.groups.yahoo.com/group/vantage/message/93590

With what Scott posted that should get you going.
Cheers,
Jared

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> I use the following code in a BPM to send an email to the Entry Person on a
> Sales Order when a Shop Floor Employees marks an ART SETUP operation we have
> complete.
>
> HTH
>
> Scott




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

I did create the BPM antd it seems to be running but i get the following
error and the email is not send

E-mail was not sent: 550 5.7.1 <ephraimf@...>... Relaying
denied: You must check for new mail before sending mail. [74.13.254.226]
(550)


Can someone help me on this?




On Thu, Oct 7, 2010 at 6:07 PM, <effgroups@...> wrote:

> Thanks for all
> I will try jared and scott suggestion tomorrow.
> I don't have the service connect so I cant try that.
>
> Ephraim
>
> Ephraim Feldman
> ------------------------------
> *From: * "k99ja04" <jallmond@...>
> *Sender: * vantage@yahoogroups.com
> *Date: *Thu, 07 Oct 2010 21:53:33 -0000
> *To: *<vantage@yahoogroups.com>
> *ReplyTo: * vantage@yahoogroups.com
> *Subject: *[Vantage] Re: BPM for sending email
>
>
>
> I posted some code for a similar issue here.
>
> http://tech.groups.yahoo.com/group/vantage/message/93590
>
> With what Scott posted that should get you going.
> Cheers,
> Jared
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, "Scott Litzau"
> <scott.litzau@...> wrote:
> >
> > I use the following code in a BPM to send an email to the Entry Person on
> a
> > Sales Order when a Shop Floor Employees marks an ART SETUP operation we
> have
> > complete.
> >
> > HTH
> >
> > Scott
>
>
>


[Non-text portions of this message have been removed]
Here is the code i have so far (based on Jared and Scott's examples)


I have a few problems first as the post before it doesnt send teh email but
i get a error.
Then the original Shipdate is not updated and the tt record is not found .
(the msg doesnt pop up)

What do i do wrong?

/*Create variable to hold stuff, i.e. old value and new value*/
DEF VAR msg AS CHARACTER NO-UNDO.
DEF VAR origShipDate AS CHARACTER NO-UNDO.
DEF VAR newShipDate AS CHARACTER NO-UNDO.
DEF VAR LeadDate AS CHARACTER NO-UNDO.
DEF VAR custName AS CHARACTER NO-UNDO.
DEF VAR OrderNum AS CHARACTER NO-UNDO.

/*Get original record with blank RowMod*/
FOR EACH ttOrderhed WHERE ttOrderhed.Company=CUR-COMP AND
ttOrderhed.RowMod=''
no-lock:

origShipDate = STRING(ttOrderhed.RequestDate).

/*next lines used for debugging*/

msg = "RowMod:" + STRING(ttOrderHed.RowMod).
{lib/PublishInfoMsg.i &InfoMsg = msg} .
msg = "origShipDate:" + STRING(origShipDate).
{lib/PublishInfoMsg.i &InfoMsg = msg }.
END.


/*now find changes*/
FOR EACH ttOrderHed WHERE ttOrderHed.Company = CUR-COMP AND
ttOrderHed.RowMod='U'
no-lock:


FIND FIRST Customer WHERE Customer.Company = CUR-COMP AND
Customer.CustNum = ttOrderHed.CustNum.


/*if nothing changed the next code block is skipped*/
IF AVAIL Customer THEN


DO:

newShipDate = STRING(ttOrderhed.RequestDate ).
LeadDate = STRING(ttOrderhed.NeedByDate).
custName = Customer.Name.
orderNum = STRING(ttOrderHed.OrderNum).

msg = "RowMod:" + STRING(ttOrderhed.RowMod).
{lib/PublishInfoMsg.i &InfoMsg = msg }.
msg = "newShipDate:" + newShipdate.
{lib/PublishInfoMsg.i &InfoMsg = msg }.

/*This next IF is important. Maybe someone activated the field and hit a key
which might trigger an Update event, but if the values are the same then
don't
send a notification*/

REPEAT:
/*create some email related variables*/
define variable vFrom as character no-undo initial '':U.
define variable vTo as character no-undo initial '':U.
define variable vCC as character no-undo initial '':U.
define variable vSubject as character no-undo initial '':U.
define variable vBody as character no-undo initial '':U.
define variable hEmailEx as handle no-undo.

run Bpm/BpmEmail.p persistent set hEmailEx.
/*I honestly can't remember why these integer cnt variables are in here.*/
define variable from_cnt as integer no-undo.
FIND FIRST UserFile WHERE UserFile.dcduserid =
ttCallContextClient.CurrentUserId.
IF AVAIL UserFile THEN
DO:
assign vFrom = UserFile.EMailAddress.
END.

define variable to_cnt as integer no-undo.
FIND FIRST UserFile WHERE UserFile.dcduserid = ttOrderHed.EntryPerson.
IF AVAIL UserFile THEN
DO:
assign vTo = UserFile.EMailAddress.
END.

define variable cc_cnt as integer no-undo.
assign vCC = ''.

define variable subject_cnt as integer no-undo.
assign vSubject = 'Notification: Order #: ' + STRING(OrderNum) + ' - Ship
Date Later Than Lead Date'.

define variable body_cnt as integer no-undo.
assign vBody = "Problem with ship date for following Order" + CHR(10) +
CHR(10)
+ "Customer: " + custName + CHR(10)
+ "Order Number: " + STRING(OrderNum) + CHR(10)
+ "Lead Date: " + LeadDate + CHR(10)
+ "Original ShipDate: " + origShipdate + CHR(10)
+ "New ShipDate: " + newShipdate.

run SendEmail in hEmailEx (
false,
CUR-COMP,
vFrom,
vTo,
vCC,
vSubject,
vBody,
"":U
).

/*optional variables that can be included in the SendEmail call*/
/* async as logical
company as character
emailFrom as character
emailTo as character
emailCC as character
emailSubject as character
emailText as character
emailMimeHeader as character */

IF valid-handle(hEmailEx) THEN delete procedure hEmailEx.
leave.
END.
END.
END.



Ephraim


On Tue, Oct 12, 2010 at 3:32 PM, Ephraim Feldman <effgroups@...>wrote:

> Hi All
>
> I did create the BPM antd it seems to be running but i get the following
> error and the email is not send
>
> E-mail was not sent: 550 5.7.1 <ephraimf@...>... Relaying
> denied: You must check for new mail before sending mail. [74.13.254.226]
> (550)
>
>
> Can someone help me on this?
>
>
>
>
>
> On Thu, Oct 7, 2010 at 6:07 PM, <effgroups@...> wrote:
>
>> Thanks for all
>> I will try jared and scott suggestion tomorrow.
>> I don't have the service connect so I cant try that.
>>
>> Ephraim
>>
>> Ephraim Feldman
>> ------------------------------
>> *From: * "k99ja04" <jallmond@...>
>> *Sender: * vantage@yahoogroups.com
>> *Date: *Thu, 07 Oct 2010 21:53:33 -0000
>> *To: *<vantage@yahoogroups.com>
>> *ReplyTo: * vantage@yahoogroups.com
>> *Subject: *[Vantage] Re: BPM for sending email
>>
>>
>>
>> I posted some code for a similar issue here.
>>
>> http://tech.groups.yahoo.com/group/vantage/message/93590
>>
>> With what Scott posted that should get you going.
>> Cheers,
>> Jared
>>
>> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, "Scott
>> Litzau" <scott.litzau@...> wrote:
>> >
>> > I use the following code in a BPM to send an email to the Entry Person
>> on a
>> > Sales Order when a Shop Floor Employees marks an ART SETUP operation we
>> have
>> > complete.
>> >
>> > HTH
>> >
>> > Scott
>>
>>
>>
>
>


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

This issue has to do with your mail server. Are you running Exchange?
Mail servers (rightfully) don't let just any computer relay messages
without permission. You must give permission to your Epicor Server to
relay mail (or install an email server to forward mail out).

Mark W.
Yes I'm running exchange.
But interestingly the BAM does send out emails without a problem.

I will ask our server IT to give permission. Do you know what he has to change?

Ephraim
Ephraim Feldman

-----Original Message-----
From: Mark Wonsil <mark_wonsil@...>
Sender: vantage@yahoogroups.com
Date: Tue, 12 Oct 2010 16:18:50
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BPM for sending email

Hi Ephraim,

This issue has to do with your mail server. Are you running Exchange?
Mail servers (rightfully) don't let just any computer relay messages
without permission. You must give permission to your Epicor Server to
relay mail (or install an email server to forward mail out).

Mark W.



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

In Exchange 2007+ you can either modify the default receive connector to accept anonymous connections (be careful here!), or I recommend making a specific receive connector that does allow anonymous, but only from the IP address of your Vantage server.

Cheers,
Jared

--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Yes I'm running exchange.
> But interestingly the BAM does send out emails without a problem.
>
> I will ask our server IT to give permission. Do you know what he has to change?
>
> Ephraim
> Ephraim Feldman
Thanks Jared.

But we have exchange 2003.
Do you know how to allow it there ?
Ephraim
Ephraim Feldman

-----Original Message-----
From: "k99ja04" <jallmond@...>
Sender: vantage@yahoogroups.com
Date: Wed, 13 Oct 2010 02:52:24
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email

Ephraim,

In Exchange 2007+ you can either modify the default receive connector to accept anonymous connections (be careful here!), or I recommend making a specific receive connector that does allow anonymous, but only from the IP address of your Vantage server.

Cheers,
Jared

--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Yes I'm running exchange.
> But interestingly the BAM does send out emails without a problem.
>
> I will ask our server IT to give permission. Do you know what he has to change?
>
> Ephraim
> Ephraim Feldman





[Non-text portions of this message have been removed]
My question would be; why are you receiving an error message from what appears to be a public ip address out on the internet.....

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Hi All
>
> I did create the BPM antd it seems to be running but i get the following
> error and the email is not send
>
> E-mail was not sent: 550 5.7.1 <ephraimf@...>... Relaying
> denied: You must check for new mail before sending mail. [74.13.254.226]
> (550)
>
>
> Can someone help me on this?
>
>
>
>
> On Thu, Oct 7, 2010 at 6:07 PM, <effgroups@...> wrote:
>
> > Thanks for all
> > I will try jared and scott suggestion tomorrow.
> > I don't have the service connect so I cant try that.
> >
> > Ephraim
> >
> > Ephraim Feldman
> > ------------------------------
> > *From: * "k99ja04" <jallmond@...>
> > *Sender: * vantage@yahoogroups.com
> > *Date: *Thu, 07 Oct 2010 21:53:33 -0000
> > *To: *<vantage@yahoogroups.com>
> > *ReplyTo: * vantage@yahoogroups.com
> > *Subject: *[Vantage] Re: BPM for sending email
> >
> >
> >
> > I posted some code for a similar issue here.
> >
> > http://tech.groups.yahoo.com/group/vantage/message/93590
> >
> > With what Scott posted that should get you going.
> > Cheers,
> > Jared
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, "Scott Litzau"
> > <scott.litzau@> wrote:
> > >
> > > I use the following code in a BPM to send an email to the Entry Person on
> > a
> > > Sales Order when a Shop Floor Employees marks an ART SETUP operation we
> > have
> > > complete.
> > >
> > > HTH
> > >
> > > Scott
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Hi All

Thanks we got it working

the issue was that the smtp address setup in epicor was our public IP not
our internal IP Address.

Now it works good.


Altough i still have the problem that i cannot retrieve the original
required date based on the code below. If someone can point me to the right
direction i would appreciate.
The for each doesnt find anything even the msg doesnt pop up

/*Get original record with blank RowMod*/
FOR EACH ttOrderhed WHERE ttOrderhed.Company=CUR-COMP AND
ttOrderhed.RowMod=''
no-lock:

origShipDate = STRING(ttOrderhed.RequestDate).

/*next lines used for debugging*/

msg = "RowMod:" + STRING(ttOrderHed.RowMod).
{lib/PublishInfoMsg.i &InfoMsg = msg} .
msg = "origShipDate:" + STRING(origShipDate).
{lib/PublishInfoMsg.i &InfoMsg = msg }.
END.


Ephraim


On Wed, Oct 13, 2010 at 12:31 PM, bw2868bond <bwalker@...>wrote:

>
>
> My question would be; why are you receiving an error message from what
> appears to be a public ip address out on the internet.....
>
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Ephraim
> Feldman <effgroups@...> wrote:
> >
> > Hi All
> >
> > I did create the BPM antd it seems to be running but i get the following
> > error and the email is not send
> >
> > E-mail was not sent: 550 5.7.1 <ephraimf@...>... Relaying
>
> > denied: You must check for new mail before sending mail. [74.13.254.226]
> > (550)
> >
> >
> > Can someone help me on this?
> >
> >
> >
> >
> > On Thu, Oct 7, 2010 at 6:07 PM, <effgroups@...> wrote:
> >
> > > Thanks for all
> > > I will try jared and scott suggestion tomorrow.
> > > I don't have the service connect so I cant try that.
> > >
> > > Ephraim
> > >
> > > Ephraim Feldman
> > > ------------------------------
> > > *From: * "k99ja04" <jallmond@...>
> > > *Sender: * vantage@yahoogroups.com <vantage%40yahoogroups.com>
>
> > > *Date: *Thu, 07 Oct 2010 21:53:33 -0000
> > > *To: *<vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> > > *ReplyTo: * vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > > *Subject: *[Vantage] Re: BPM for sending email
> > >
> > >
> > >
> > > I posted some code for a similar issue here.
> > >
> > > http://tech.groups.yahoo.com/group/vantage/message/93590
> > >
> > > With what Scott posted that should get you going.
> > > Cheers,
> > > Jared
> > >
> > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>, "Scott Litzau"
>
> > > <scott.litzau@> wrote:
> > > >
> > > > I use the following code in a BPM to send an email to the Entry
> Person on
> > > a
> > > > Sales Order when a Shop Floor Employees marks an ART SETUP operation
> we
> > > have
> > > > complete.
> > > >
> > > > HTH
> > > >
> > > > Scott
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
In Exchange System Manager, assuming when you installed Exchange you
accepted the default setup options: Administrative Groups->First
Administrative Group->Servers->(your server
name)->Protocols->SMTP->Default SMTP Server

Your administrative group and SMTP server instance name might be
different, but probably not.

Right-click on the SMTP server and select Properties.

Click on the Access Tab, and at the bottom click on the Relay...
button.

Here you can configure which hosts can send e-mail to domains outside
of those that your mail server thinks it is authoritative for (i.e.
'relaying').

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of effgroups@...
Sent: Wednesday, October 13, 2010 11:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BPM for sending email

Thanks Jared.

But we have exchange 2003.
Do you know how to allow it there ?
Ephraim
Ephraim Feldman

-----Original Message-----
From: "k99ja04" <jallmond@...>
Sender: vantage@yahoogroups.com
Date: Wed, 13 Oct 2010 02:52:24
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM for sending email

Ephraim,

In Exchange 2007+ you can either modify the default receive connector to
accept anonymous connections (be careful here!), or I recommend making a
specific receive connector that does allow anonymous, but only from the
IP address of your Vantage server.

Cheers,
Jared

--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Yes I'm running exchange.
> But interestingly the BAM does send out emails without a problem.
>
> I will ask our server IT to give permission. Do you know what he has
to change?
>
> Ephraim
> Ephraim Feldman





[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/linksYahoo! Groups Links