Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Tiffany Ziegler]

Again, new computer (sigh). In the past, I used Macros and Mail Merge to enter cash receipts for some loan proceeds we receive. After doing the mail merge in word, I would save the document as a .txt file. Then in windows, I’d change the file extension to .mac in order to make it a macro file. Now, I have Windows 10 and within windows explorer the file extension is not included in the file name so i cannot change it from .txt to .mac. I tried simply typing .mac at the end but of course, this does not change the file type. 

Anyone know how I can convert my mail merge document to a macro file so I can run it in GP?

——————————
Tiffany Ziegler
Vice President & Controller
Velcor Leasing Corporation
Madison WI
——————————

[Tiffany Ziegler]

Nevermind – I found the option to show the extensions. I just need a little patience 😉

——————————
Tiffany Ziegler
Vice President & Controller
Velcor Leasing Corporation
Madison WI
——————————
——————————————-

[Beat Bucher]

Glad you found it so quickly Tiffany,
For those who are less tech savy or still wondering / or new  to Wi10. it’s as easy as 1-2-3-4 :

Switch to the tab ‘View’ and UnCheck the box ‘Hide extensions for known file types’
Enjoy !

PS: you can save step 1 and click directly on the ‘View’ tab..
——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[David Musgrave]

For more information on the Mail Merge Macro technique see my article.

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Jo deRuiter]

Wanted to update folks, David’s blog was moved from the link location above, but I found it again on his WordPress site in case you, too are looking for it:

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

——————————
Jo deRuiter, MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
770-906-4504 (Cell)

——————————
——————————————-

[David Musgrave]

Thanks Jo

This was all part of the task of saving the Developing for Dynamics GP ?blog which I completed on the 19th March 2019.

https://winthropdc.wordpress.com/2019/03/19/developing-for-dynamics-gp-blog-saved/

All the still relevant articles can be found under the Developing for Dynamics GP category

https://winthropdc.wordpress.com/category/developing-for-dynamics-gp/

Regards

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-