Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 02-05-2019, 03:32 AM
Kalü Kalü is offline Start MailMerge for 3 different Word documents in Excel depending on value in column A Windows 10 Start MailMerge for 3 different Word documents in Excel depending on value in column A Office 2010 32bit
Advanced Beginner
Start MailMerge for 3 different Word documents in Excel depending on value in column A
 
Join Date: Apr 2018
Posts: 43
Kalü is on a distinguished road
Default

The excel-vba code for mailmerge single documents I copied from your suggested sticky thread is giving me word docs for every entry, also for those that have value 0 in column A (although they are kind of empty, they are still there) and I dont know how to change that

The IF-fields are kind of hidden in the text that should actually follow after the IF... see here for example: https://imgur.com/a/DupAVkf

That makes it kind of hard to keep an overview... Sadly I cannot paste the text into excel cells because of formatting and length At least i tried that before and it didnt take all text into word only the first sentences.

I tried to save Auto-Text and insert that after the "{IF{MERGEFIELD Anz}= "1"- expressions but it inserts only the text. Would be great of there would just be any fieldcode/field/cross reference or whatever and the full text only be shown when exit the Alt-F9 view by pressing F9.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Start MailMerge for 3 different Word documents in Excel depending on value in column A Mailmerge Excel with a Master Word Template (via VBA) stevenel Excel Programming 8 08-14-2018 03:05 PM
Start MailMerge for 3 different Word documents in Excel depending on value in column A Rounding Up or Down depending on Start & End time richardst Excel 4 06-21-2016 06:03 PM
Marking specific cells depending on start and end time entered ellebb85 Excel Programming 0 01-17-2016 02:50 AM
Start MailMerge for 3 different Word documents in Excel depending on value in column A documents saved with double column revert to single column when re-opened danw Word 6 04-08-2015 06:24 AM
Merge Word documents using a mailmerge field Concertina Mail Merge 3 02-18-2013 04:12 AM

Other Forums: Access Forums

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


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