Data directive BPM email - I would like to include table/field d

Yahoo Archive
1
Shouldn't these lines

Assign vPackNum = ShipDtl.PackNum.

assign vBody = vBody + 'See Pack Slip:'.



be

Assign vPackNum = string(ShipDtl.PackNum).
assign vBody = vBody + 'See Pack Slip: ' + vPackNum.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Monday, March 07, 2011 11:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Data directive BPM email - I would like to
include table/field data





Hi Carl,

Unfortunately, no email template is available with a data directive BPM.
I am using this because it is the only way I've been able to fire an
email off of the ShipDtl table.
I've tried pre, base and post method directives, and BAM's no luck.
I'm not sure what is so different about the ShipDtl table.

So I finally have an email sending, just no data in it.
I've tried adding ttShipDtl and ShipDtl lines, no luck.

Any ideas?

Thanks,

Bruce

Here is the email template I'm using:

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.

/* Get Pack Details */
define variable vPackNum like ShipDtl.PackNum no-undo initial '':U.
Find ShipDtl where (ShipDtl.PackNum = ttShipDtl.Packnum) no-lock
no-error.

run Bpm/BpmEmail.p persistent set hEmailEx.
define variable from_cnt as integer no-undo.
assign vFrom = vFrom + 'Vantage@...
<mailto:%27Vantage%40bogus.test> '.

define variable to_cnt as integer no-undo.
assign vTo = vTo + 'bruceo@... <mailto:%27bruceo%40bogus.test> '.

define variable cc_cnt as integer no-undo.
assign vCC = vCC + 'bruceo@... <mailto:%27bruceo%40bogus.test> '.

define variable subject_cnt as integer no-undo.
assign vSubject = vSubject + 'Subject Pack Slip'.

define variable body_cnt as integer no-undo.
/* assign vBody = vBody + Pack Details. */
/* assign vPackNum = ttShipDtl.PackNum. */
Assign vPackNum = ShipDtl.PackNum.
assign vBody = vBody + 'See Pack Slip:'.

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.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"CarlH" <carl.heeder@...> wrote:
>
> If you simply want to add information from the ShipDtl record, go to
the email template and use the Insert button. This will allow you to
choose specific fields from the ShipDtl record.
>
> If you want to show details from more than one ShipDtl record in one
email, contact me and I can also give you a technique for that as well.
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"cooner_55421" <cooner_55421@> wrote:
> >
> > Hi,
> >
> > I am trying to add record details to an email from a BPM action.
> > This is for data directive BPM.
> > Can anybody share an example?
> >
> > The data directive table is ShipDtl.
> > - Criteria: ShipCmpl = false
> > - Action: Advanced = using the basic "Email template example for
BPM" from Epicor. It sends an email but without record details.
> >
> >
> > Thanks
> >
>





[Non-text portions of this message have been removed]
2
If you simply want to add information from the ShipDtl record, go to the email template and use the Insert button. This will allow you to choose specific fields from the ShipDtl record.

If you want to show details from more than one ShipDtl record in one email, contact me and I can also give you a technique for that as well.


--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi,
>
> I am trying to add record details to an email from a BPM action.
> This is for data directive BPM.
> Can anybody share an example?
>
> The data directive table is ShipDtl.
> - Criteria: ShipCmpl = false
> - Action: Advanced = using the basic "Email template example for BPM" from Epicor. It sends an email but without record details.
>
>
> Thanks
>