Email individual invoices
I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query [...]
Answer Question
| April 10, 2013 4:10 PM
Email, Macros
I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query [...]
Answer Question
| April 10, 2013 4:10 PM
Email, Macros
VBA to copy sent email subject and to fields
We use a Corel X5 macro along with Outlook 2007&2010 here to send or “export” drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and “TO” fields to a [...]
Answer Question
| October 19, 2012 3:15 PM
CorelDRAW, Macros, outlook2010, outloook 2007, VBA
We use a Corel X5 macro along with Outlook 2007&2010 here to send or “export” drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and “TO” fields to a [...]
Answer Question
| October 19, 2012 3:15 PM
CorelDRAW, Macros, outlook2010, outloook 2007, VBA
Microsoft Access 2010 DB Macro that allows a count of a date filter, and an email to be sent
Hello, I was wondering if, within Outlook 2010, is it possible to have a script run that runs the date filter command within Access,displaying the weekly total number of values logged within the Access database. Once it pulls that value, I then would like it to send an email saying the count to a specific [...]
Answer Question
| June 18, 2012 11:05 PM
Access 2010, Macros, Microsoft Exchange, Outlook 2010
Hello, I was wondering if, within Outlook 2010, is it possible to have a script run that runs the date filter command within Access,displaying the weekly total number of values logged within the Access database. Once it pulls that value, I then would like it to send an email saying the count to a specific [...]
Answer Question
| June 18, 2012 11:05 PM
Access 2010, Macros, Microsoft Exchange, Outlook 2010
Macro or not???
I have a spreadsheet for a team of agents stats, the front page has agents along the top and stats down the left hand side. Each subsequent tab has that agents stats down the side and each column is the progressing weeks and a tab for the team which collates the agents info in to [...]
Answer Question
| February 28, 2012 11:15 AM
Macros
I have a spreadsheet for a team of agents stats, the front page has agents along the top and stats down the left hand side. Each subsequent tab has that agents stats down the side and each column is the progressing weeks and a tab for the team which collates the agents info in to [...]
Answer Question
| February 28, 2012 11:15 AM
Macros
Macro Script on AS/400
Hi, Currently We are getting a Report on Monthly Basis using Macro script which runs manually on next day to monthend. Now, We have requirement for generating the Report on Monthend Date itself as part of over night process. Is there anyway to automate the Macro Scripts in AS400. Please suggest. Pradeep.
Answer Question
| March 31, 2012 5:56 AM
AS/400, AS/400 macros, Macros
Hi, Currently We are getting a Report on Monthly Basis using Macro script which runs manually on next day to monthend. Now, We have requirement for generating the Report on Monthend Date itself as part of over night process. Is there anyway to automate the Macro Scripts in AS400. Please suggest. Pradeep.
Answer Question
| March 31, 2012 5:56 AM
AS/400, AS/400 macros, Macros
Using macros in Lotus Notes
Does LN have the ability to record and run macros? In other words can LN automatically “record” a series of rote tasks and write a macro that can be run, in much the same way that excel can? If so can someone instruct me on how to do so? Thanks
Answer Question
| May 19, 2011 1:00 PM
Lotus Notes, Lotus Notes 8.5.1, Macros
Does LN have the ability to record and run macros? In other words can LN automatically “record” a series of rote tasks and write a macro that can be run, in much the same way that excel can? If so can someone instruct me on how to do so? Thanks
Answer Question
| May 19, 2011 1:00 PM
Lotus Notes, Lotus Notes 8.5.1, Macros
Create a macro in Excel 2007 to disable save
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
How to accept user input and display the value in Excel 2007 macros
I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows ‘TRUE’. Any ideas?
Answer Question
| January 28, 2011 4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros
I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows ‘TRUE’. Any ideas?
Answer Question
| January 28, 2011 4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros
iSeries Access Macro to run from a program.
I think I’ve asked the same question some months ago but didn’t get any answer and couldn’t be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this [...]
Answer Question
| January 25, 2011 2:38 AM
iSeries Access, iSeries macros, Macros, V5R4
I think I’ve asked the same question some months ago but didn’t get any answer and couldn’t be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this [...]
Answer Question
| January 25, 2011 2:38 AM
iSeries Access, iSeries macros, Macros, V5R4
Excel macro – create a chart
I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and [...]
Answer Question
| January 26, 2011 5:05 PM
Excel 2007, Excel Charts, Excel macros, Macros
I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and [...]
Answer Question
| January 26, 2011 5:05 PM
Excel 2007, Excel Charts, Excel macros, Macros
Excel 2003 Macros with Org Chart Parent
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]
Answer Question
| March 11, 2011 3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]
Answer Question
| March 11, 2011 3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros
Should I disable macros on a network-wide basis?
Just wondering if it is generally a policy to disable macros from Word, etc. Is there a safe macros list or should they all be disabled? How would I go about doing this across the network?
Answer Question
| December 15, 2010 2:26 PM
Macros, Network Policies, Network security, Network Security Management, Network Security Policies
Just wondering if it is generally a policy to disable macros from Word, etc. Is there a safe macros list or should they all be disabled? How would I go about doing this across the network?
Answer Question
| December 15, 2010 2:26 PM
Macros, Network Policies, Network security, Network Security Management, Network Security Policies
Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Date Range in Excel Macro
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]
Answer Question
| December 2, 2010 4:18 PM
Agents, excel, Excel macros, Macros
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]
Answer Question
| December 2, 2010 4:18 PM
Agents, excel, Excel macros, Macros
converting a macro
can a macro made in WordPerfect be converted over to Word?
Answer Question
| November 19, 2010 9:47 PM
Conversion, Macros
can a macro made in WordPerfect be converted over to Word?
Answer Question
| November 19, 2010 9:47 PM
Conversion, Macros
SAS date macro variable
Hello, i’m new in SAS I’m writing this code below : data _test_ ; d1 = put(mdy(month(today())- 1,1,year(today())-1),yymmdd10.); call symput(‘d1′,”‘”||put(d1,9.)||” 23:59:59′”) ; d2 = put(mdy(month(today())- 1,1,year(today())),yymmdd10.); call symput(‘d2′,”‘”||put(d2,9.)||” 23:59:59′”) ; run ; %put d1; My question is 1. My understanding is %put [...]
Answer Question
| October 11, 2010 5:12 PM
Macros, Programming Languages, SAS 9.2, SAS programming
Hello, i’m new in SAS I’m writing this code below : data _test_ ; d1 = put(mdy(month(today())- 1,1,year(today())-1),yymmdd10.); call symput(‘d1′,”‘”||put(d1,9.)||” 23:59:59′”) ; d2 = put(mdy(month(today())- 1,1,year(today())),yymmdd10.); call symput(‘d2′,”‘”||put(d2,9.)||” 23:59:59′”) ; run ; %put d1; My question is 1. My understanding is %put [...]
Answer Question
| October 11, 2010 5:12 PM
Macros, Programming Languages, SAS 9.2, SAS programming
Macro date a year from today
Does any know how to create a year date from today ? for example today = 9/3/2010 I would like to get the macro variable that give 9/1/2009
Answer Question
| October 11, 2010 3:36 PM
Date calculation, Macros, Programming Languages, SAS programming
Does any know how to create a year date from today ? for example today = 9/3/2010 I would like to get the macro variable that give 9/1/2009
Answer Question
| October 11, 2010 3:36 PM
Date calculation, Macros, Programming Languages, SAS programming
Conditions in Automation Macros
I am trying to figure out how to make a condition in an automation macros that says If [Forms!testing!hc leader] = (Leaders name) then open (query name) and apply output to (report name). Can anyone help me? The parentheses are not in the macros that was put there for this question. Thanks!
Answer Question
| October 1, 2010 3:30 PM
Automation, Automation engineering, Macros
I am trying to figure out how to make a condition in an automation macros that says If [Forms!testing!hc leader] = (Leaders name) then open (query name) and apply output to (report name). Can anyone help me? The parentheses are not in the macros that was put there for this question. Thanks!
Answer Question
| October 1, 2010 3:30 PM
Automation, Automation engineering, Macros
Running macros when the reset key is locked
include the [reset] function in a Macro to reset the operator input error I was trying to include the [reset] key in my macro to “unlock” the keyboard and continue the macro. Can this be done? Or is there a setting I need to play around to allow macro’s to run when the key [...]
Answer Question
| February 17, 2010 4:21 PM
AS/400, Macros
include the [reset] function in a Macro to reset the operator input error I was trying to include the [reset] key in my macro to “unlock” the keyboard and continue the macro. Can this be done? Or is there a setting I need to play around to allow macro’s to run when the key [...]
Answer Question
| February 17, 2010 4:21 PM
AS/400, Macros
Hide macro
I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet. This has to be automatic (multi-user friendly) rather than using advanced filtering.
Answer Question
| March 16, 2010 5:58 PM
Excel macros, Macros, Microsoft Excel macros
I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet. This has to be automatic (multi-user friendly) rather than using advanced filtering.
Answer Question
| March 16, 2010 5:58 PM
Excel macros, Macros, Microsoft Excel macros
