Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2012, 11:04 AM
Abacus1234 Abacus1234 is offline Can a Form_Letter contain a macro? Windows Vista Can a Form_Letter contain a macro? Office 2010 32bit
Novice
Can a Form_Letter contain a macro?
 
Join Date: Nov 2011
Posts: 24
Abacus1234 is on a distinguished road
Default Can a Form_Letter contain a macro?

I have code which selects a document, merges it with data from an Access Data base and brings it to the screen as a form-letter that can be edited and printed.



The master document contains a macro which would email this document, but the form-letter loses the macro.

Does anyone know if a form-letter can be made to reference a macro?

Thanks.
Reply With Quote
  #2  
Old 05-30-2012, 02:00 PM
Charles Kenyon Charles Kenyon is online now Can a Form_Letter contain a macro? Windows Vista Can a Form_Letter contain a macro? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

A merge result document is not attached to the original template.

I have a macro in a global add-in that attaches a template holding macros I use in my merge result file. I customized the ribbon and put a button to run that macro on a custom tab. After I finish my merge and am in the result document, I click that button and it attaches the template holding my macros.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft