web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Inventory Item Macros

(0) ShareShare
ReportReport
Posted on by 25

I'm trying to get some help clarification on macros.

Currently when we build the macro then mail merge and save the file as updatefile.mac.

The user currently says that the updatefile.mac has to be open on a computer and then on a different computer with GP they chose Inventory>Item>Tools>Macro>Play...

Why does the updatefile.mac need to be open? If we don't have it open we get an error.

Thanks


GP Version GP2013

Categories:
I have the same question (0)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,095 Most Valuable Professional on at

    When you record a macro, it will track the window you currently have open.

    When you replay the macro, you will need to start with that same window open.

    Sometimes it is better to start with no windows open and open the window as the first part of the macro.

    If you are creating a mail merge macro, it will probably need the window open to start with so that each loop comes back to the same location in the application.

    https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

    One thing to try is changing the macro with notepad.exe to change the first NewActiveWin to ActivateWindow.

     

    Personally, I would not macros as they cannot handle any variations and can only toggle checkbox (can't set to true or false).

    A better approach is to drive the user interface with code using a tool like GP Power Tools. While it is possible with VBA (end of life), or VSTools or Dexterity it is much more work and needs external tools.

    Regards

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans