Emailing Sales order confirmations

Thanks again...

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> The variables are:
> async as logical
> company as character
> emailFrom as character
> emailTo as character
> emailCC as character
> emailSubject as character
> emailText as character
> emailMimeHeader as character
>
> and I believe the :U indicates that the preceding can not be translated to other programming languages (Untranslatable)
>
> --- In vantage@yahoogroups.com, "CarlH" <carl.heeder@> wrote:
> >
> > ?Thanks to you both. I did use Sean's technique and it worked well.
> >
> > Do either of you know what the parameters are used for in the
> > > run SendEmail in mhEmailProc (false,CUR-COMP,mFrom,mTo,mCc,
> > mSubject, mBody,"":U
> >
> > especially the False, the "" and the terminal U:?
> >
> > it worked but I am curious
> >
> >
> > --- In vantage@yahoogroups.com, "CarlH" <carl.heeder@> wrote:
> > >
> > >
> > > I'll give it a go. Thanks
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> > > >
> > > >  We're on Vantage 6.10, we do this- we set up a 'BAM' (alert), configured the Order VB Form to include the customer email address, then loop thru the Order to get the info , write everything to the 'email body', very similar to the procedure from Sean.
> > > >
> > > > --- On Tue, 2/22/11, Sean McDaniel <smcdaniel@> wrote:
> > > >
> > > >
> > > > From: Sean McDaniel <smcdaniel@>
> > > > Subject: RE: [Vantage] Emailing Sales order confirmations
> > > > To: vantage@yahoogroups.com, vantage@yahoogroups.com
> > > > Date: Tuesday, February 22, 2011, 2:38 PM
> > > >
> > > >
> > > > ÂÂ
> > > >
> > > >
> > > >
> > > > You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
> > > > Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
> > > > For carriage return/line feeds use "~n"
> > > >
> > > > Here is an email example through 4gl...
> > > >
> > > > define variable mFrom as character.
> > > >
> > > > define variable mTo as character.
> > > >
> > > > define variable mCc as character.
> > > >
> > > > define variable mSubject as character.
> > > >
> > > > define variable mBody as character.
> > > >
> > > > define variable mhEmailProc as handle no-undo.
> > > >
> > > > run Bpm/BpmEmail.p persistent set mhEmailProc.
> > > >
> > > > for each ttDMRCorAct.
> > > >
> > > > assign mFrom = <mail from>
> > > >
> > > > mTo = <mail to>
> > > >
> > > > mSubject = <subject
> > > >
> > > > mBody = <body>.
> > > >
> > > > run SendEmail in mhEmailProc (
> > > >
> > > > false,
> > > >
> > > > CUR-COMP,
> > > >
> > > > mFrom,
> > > >
> > > > mTo,
> > > >
> > > > mCc,
> > > >
> > > > mSubject,
> > > >
> > > > mBody,
> > > >
> > > > "":U
> > > >
> > > > ).
> > > >
> > > > if valid-handle( mhEmailProc) then delete procedure mhEmailProc.
> > > >
> > > > leave.
> > > >
> > > > end.
> > > >
> > > > ________________________________
> > > >
> > > > From: vantage@yahoogroups.com on behalf of CarlH
> > > > Sent: Tue 2/22/2011 2:30 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Emailing Sales order confirmations
> > > >
> > > > We'd like to email a sales order confirmation to each sales rep when a neew order is entered.
> > > >
> > > > I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email
> > > >
> > > > Does anybody else ahve an idea?
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>
We'd like to email a sales order confirmation to each sales rep when a neew order is entered.

I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email

Does anybody else ahve an idea?
You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
For carriage return/line feeds use "~n"

Here is an email example through 4gl...

define variable mFrom as character.



define variable mTo as character.

define variable mCc as character.

define variable mSubject as character.

define variable mBody as character.

define variable mhEmailProc as handle no-undo.

run Bpm/BpmEmail.p persistent set mhEmailProc.

for each ttDMRCorAct.

assign mFrom = <mail from>

mTo = <mail to>

mSubject = <subject

mBody = <body>.

run SendEmail in mhEmailProc (

false,

CUR-COMP,

mFrom,

mTo,

mCc,

mSubject,

mBody,

"":U

).

if valid-handle( mhEmailProc) then delete procedure mhEmailProc.

leave.

end.


________________________________

From: vantage@yahoogroups.com on behalf of CarlH
Sent: Tue 2/22/2011 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Emailing Sales order confirmations




We'd like to email a sales order confirmation to each sales rep when a neew order is entered.

I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email

Does anybody else ahve an idea?






[Non-text portions of this message have been removed]
 We're on Vantage 6.10, we do this- we set up a 'BAM' (alert), configured the Order VB Form to include the customer email address, then loop thru the Order to get the info , write everything to the 'email body', very similar to the procedure from Sean.

--- On Tue, 2/22/11, Sean McDaniel <smcdaniel@...> wrote:


From: Sean McDaniel <smcdaniel@...>
Subject: RE: [Vantage] Emailing Sales order confirmations
To: vantage@yahoogroups.com, vantage@yahoogroups.com
Date: Tuesday, February 22, 2011, 2:38 PM


Â



You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
For carriage return/line feeds use "~n"

Here is an email example through 4gl...

define variable mFrom as character.

define variable mTo as character.

define variable mCc as character.

define variable mSubject as character.

define variable mBody as character.

define variable mhEmailProc as handle no-undo.

run Bpm/BpmEmail.p persistent set mhEmailProc.

for each ttDMRCorAct.

assign mFrom = <mail from>

mTo = <mail to>

mSubject = <subject

mBody = <body>.

run SendEmail in mhEmailProc (

false,

CUR-COMP,

mFrom,

mTo,

mCc,

mSubject,

mBody,

"":U

).

if valid-handle( mhEmailProc) then delete procedure mhEmailProc.

leave.

end.

________________________________

From: vantage@yahoogroups.com on behalf of CarlH
Sent: Tue 2/22/2011 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Emailing Sales order confirmations

We'd like to email a sales order confirmation to each sales rep when a neew order is entered.

I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email

Does anybody else ahve an idea?

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











[Non-text portions of this message have been removed]
I'll give it a go. Thanks



--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
>  We're on Vantage 6.10, we do this- we set up a 'BAM' (alert), configured the Order VB Form to include the customer email address, then loop thru the Order to get the info , write everything to the 'email body', very similar to the procedure from Sean.
>
> --- On Tue, 2/22/11, Sean McDaniel <smcdaniel@...> wrote:
>
>
> From: Sean McDaniel <smcdaniel@...>
> Subject: RE: [Vantage] Emailing Sales order confirmations
> To: vantage@yahoogroups.com, vantage@yahoogroups.com
> Date: Tuesday, February 22, 2011, 2:38 PM
>
>
> ÂÂ
>
>
>
> You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
> Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
> For carriage return/line feeds use "~n"
>
> Here is an email example through 4gl...
>
> define variable mFrom as character.
>
> define variable mTo as character.
>
> define variable mCc as character.
>
> define variable mSubject as character.
>
> define variable mBody as character.
>
> define variable mhEmailProc as handle no-undo.
>
> run Bpm/BpmEmail.p persistent set mhEmailProc.
>
> for each ttDMRCorAct.
>
> assign mFrom = <mail from>
>
> mTo = <mail to>
>
> mSubject = <subject
>
> mBody = <body>.
>
> run SendEmail in mhEmailProc (
>
> false,
>
> CUR-COMP,
>
> mFrom,
>
> mTo,
>
> mCc,
>
> mSubject,
>
> mBody,
>
> "":U
>
> ).
>
> if valid-handle( mhEmailProc) then delete procedure mhEmailProc.
>
> leave.
>
> end.
>
> ________________________________
>
> From: vantage@yahoogroups.com on behalf of CarlH
> Sent: Tue 2/22/2011 2:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Emailing Sales order confirmations
>
> We'd like to email a sales order confirmation to each sales rep when a neew order is entered.
>
> I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email
>
> Does anybody else ahve an idea?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
?Thanks to you both. I did use Sean's technique and it worked well.

Do either of you know what the parameters are used for in the
> run SendEmail in mhEmailProc (false,CUR-COMP,mFrom,mTo,mCc,
mSubject, mBody,"":U

especially the False, the "" and the terminal U:?

it worked but I am curious


--- In vantage@yahoogroups.com, "CarlH" <carl.heeder@...> wrote:
>
>
> I'll give it a go. Thanks
>
>
>
> --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> >
> >  We're on Vantage 6.10, we do this- we set up a 'BAM' (alert), configured the Order VB Form to include the customer email address, then loop thru the Order to get the info , write everything to the 'email body', very similar to the procedure from Sean.
> >
> > --- On Tue, 2/22/11, Sean McDaniel <smcdaniel@> wrote:
> >
> >
> > From: Sean McDaniel <smcdaniel@>
> > Subject: RE: [Vantage] Emailing Sales order confirmations
> > To: vantage@yahoogroups.com, vantage@yahoogroups.com
> > Date: Tuesday, February 22, 2011, 2:38 PM
> >
> >
> > ÂÂ
> >
> >
> >
> > You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
> > Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
> > For carriage return/line feeds use "~n"
> >
> > Here is an email example through 4gl...
> >
> > define variable mFrom as character.
> >
> > define variable mTo as character.
> >
> > define variable mCc as character.
> >
> > define variable mSubject as character.
> >
> > define variable mBody as character.
> >
> > define variable mhEmailProc as handle no-undo.
> >
> > run Bpm/BpmEmail.p persistent set mhEmailProc.
> >
> > for each ttDMRCorAct.
> >
> > assign mFrom = <mail from>
> >
> > mTo = <mail to>
> >
> > mSubject = <subject
> >
> > mBody = <body>.
> >
> > run SendEmail in mhEmailProc (
> >
> > false,
> >
> > CUR-COMP,
> >
> > mFrom,
> >
> > mTo,
> >
> > mCc,
> >
> > mSubject,
> >
> > mBody,
> >
> > "":U
> >
> > ).
> >
> > if valid-handle( mhEmailProc) then delete procedure mhEmailProc.
> >
> > leave.
> >
> > end.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com on behalf of CarlH
> > Sent: Tue 2/22/2011 2:30 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Emailing Sales order confirmations
> >
> > We'd like to email a sales order confirmation to each sales rep when a neew order is entered.
> >
> > I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email
> >
> > Does anybody else ahve an idea?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
The variables are:
async as logical
company as character
emailFrom as character
emailTo as character
emailCC as character
emailSubject as character
emailText as character
emailMimeHeader as character

and I believe the :U indicates that the preceding can not be translated to other programming languages (Untranslatable)

--- In vantage@yahoogroups.com, "CarlH" <carl.heeder@...> wrote:
>
> ?Thanks to you both. I did use Sean's technique and it worked well.
>
> Do either of you know what the parameters are used for in the
> > run SendEmail in mhEmailProc (false,CUR-COMP,mFrom,mTo,mCc,
> mSubject, mBody,"":U
>
> especially the False, the "" and the terminal U:?
>
> it worked but I am curious
>
>
> --- In vantage@yahoogroups.com, "CarlH" <carl.heeder@> wrote:
> >
> >
> > I'll give it a go. Thanks
> >
> >
> >
> > --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> > >
> > >  We're on Vantage 6.10, we do this- we set up a 'BAM' (alert), configured the Order VB Form to include the customer email address, then loop thru the Order to get the info , write everything to the 'email body', very similar to the procedure from Sean.
> > >
> > > --- On Tue, 2/22/11, Sean McDaniel <smcdaniel@> wrote:
> > >
> > >
> > > From: Sean McDaniel <smcdaniel@>
> > > Subject: RE: [Vantage] Emailing Sales order confirmations
> > > To: vantage@yahoogroups.com, vantage@yahoogroups.com
> > > Date: Tuesday, February 22, 2011, 2:38 PM
> > >
> > >
> > > ÂÂ
> > >
> > >
> > >
> > > You'd have to do an ABL bpm, essentially calling the email portion from within the 4GL code.
> > > Once you're in the ABL you can loop through the OrderHed, OrderDtl and OrderRel tables to get all of the pertinant information for the body.
> > > For carriage return/line feeds use "~n"
> > >
> > > Here is an email example through 4gl...
> > >
> > > define variable mFrom as character.
> > >
> > > define variable mTo as character.
> > >
> > > define variable mCc as character.
> > >
> > > define variable mSubject as character.
> > >
> > > define variable mBody as character.
> > >
> > > define variable mhEmailProc as handle no-undo.
> > >
> > > run Bpm/BpmEmail.p persistent set mhEmailProc.
> > >
> > > for each ttDMRCorAct.
> > >
> > > assign mFrom = <mail from>
> > >
> > > mTo = <mail to>
> > >
> > > mSubject = <subject
> > >
> > > mBody = <body>.
> > >
> > > run SendEmail in mhEmailProc (
> > >
> > > false,
> > >
> > > CUR-COMP,
> > >
> > > mFrom,
> > >
> > > mTo,
> > >
> > > mCc,
> > >
> > > mSubject,
> > >
> > > mBody,
> > >
> > > "":U
> > >
> > > ).
> > >
> > > if valid-handle( mhEmailProc) then delete procedure mhEmailProc.
> > >
> > > leave.
> > >
> > > end.
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com on behalf of CarlH
> > > Sent: Tue 2/22/2011 2:30 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Emailing Sales order confirmations
> > >
> > > We'd like to email a sales order confirmation to each sales rep when a neew order is entered.
> > >
> > > I thought about doing this from a BPM but cannot figure out how to include all the SO detail info in one email
> > >
> > > Does anybody else ahve an idea?
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>