Command button - Lotus notes email

brt21

New Member
Joined
Oct 1, 2015
Messages
25
Hello,

my name is bharath. I am now working on a complex process planning. i have integrated data from various sources and grouped in several pivot tables according to my boss's requirement. My questions are as follows:

1. I know how to filter the Pivot table (I use slicers in my case). I want to know if it is possible to automatically update the selection in another worksheet or a word file that already has a template of the material orders.:ROFLMAO:
2. Its a sequel to my previous question. I know how to create an ActiveX command button (Developer tab-->Insert). since I don't have much programming knowledge, I have no idea how to make the command button to work in such a way that it automatically attaches the current 'worksheet' in the mail (lotus notes) with a defined subject and recipient. And it shall vary according to my selection in the pivot table.

Since my data is confidential, I can't provide a link to my doc. My question may be amateurish.., I believe some of you can help me out!:confused::confused:

good day,
bharath
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,858
Messages
5,766,796
Members
425,379
Latest member
thedoctor00

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