Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-28-2018, 02:28 PM
macropod's Avatar
macropod macropod is offline Is this possible to create? Windows 7 64bit Is this possible to create? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your post is confusing, at best and whatever you're trying to achieve remains a mystery.

Documents and templates are not the same thing. Mailmerges don't ordinarily use templates - they use mailmerge main documents. Similarly, INCLUDETEXT fields would ordinarily point to documents, not templates.

Furthermore, it is far from clear what relationship exists between what you're calling the 'Mail Merge Template' and the other two 'templates'. You also refer to having the user 'go through the Mail Merge Fields'. To what end?

A mailmerge main document can conditionally insert content from other documents via INCLUDETEXT fields and those fields can themselves reference documents/ranges containing mergefields of their own.

As for your use of DDE, that is seriously outdated technology. Using the OLE DB provider - which is the default for Word 2002 and later - the formatting of the output in Word is independent of the data source format. Amongst other things, that means you don't have to format the data in Excel the way you want it to appear in the output (which can even necessitate having multiple columns with the same data formatted different ways with OLE). The Mailmerge Tips and Tricks 'Sticky' thread at the top of the Mail Merge forum :
https://www.msofficeforums.com/mail-...ps-tricks.html
shows how field switches can be used to generate a wide variety of formats that are independent of that of the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
excel vba, mail merge, word vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create PDF Anitha Word 5 02-01-2018 11:13 PM
Is this possible to create? How to create this? Jil.10 Word 4 05-09-2016 11:56 AM
how to create a special template to create a clear lay out for plain text hex Word 1 04-01-2016 09:58 AM
Is this possible to create? Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Is this possible to create? create a datafile acki Excel 1 01-26-2012 07:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 AM.


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