VBA + SAP + MAIL Macro help

santhoshlk

Board Regular
Joined
Feb 6, 2006
Messages
206
Hi..

I dont know is this possible or not... can any one help in this.

Iam usinf SAP accounting pakage. and when ever i enter an sales order and save if the sales order of the customer exceeds his credit limit then i get a mesege saying that he exceeded the credit limit and in the status bar of SAP shows me the sales order no.

now i have a list of customers with sales person responsibble for each customer and his e-mail IDs also.

is it possible to create a macro to automatically send a mail to that respective sales person saying that customer code, name with sales order number that has blocked.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

shadow12345

Well-known Member
Joined
May 10, 2004
Messages
1,238
I would suggest it would be easier to run this as an export from SAP... if i remember correctly its a database somewhat like Orcale.

Perhaps you could export the customer name credit limit and outstanding balance into a CSV or excel file... then it wouldn't be that hard to do what you want to do. But without having the data in a format excel can read, you would have to query the database itself, and im not sure how you would go about that in SAP, or even if your companies IT would allow you to do that.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,329
Members
414,445
Latest member
walramgo02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top