Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2018, 06:12 AM
stevenel stevenel is offline Mailmerge Excel with a Master Word Template (via VBA) Windows 7 64bit Mailmerge Excel with a Master Word Template (via VBA) Office 2013
Novice
Mailmerge Excel with a Master Word Template (via VBA)
 
Join Date: Jul 2018
Posts: 26
stevenel is on a distinguished road
Default


Initially, it is an Excel file. Before I merge, I save it as a csv file because there are too many mergefields (more than 255) in my original Merge Excel File. If I save it as xslm, Word cannot merge it because it stops at 255 mergefields. That's why I save it as csv and merge. Is there a solution?
Reply With Quote
  #2  
Old 08-14-2018, 03:05 PM
macropod's Avatar
macropod macropod is offline Mailmerge Excel with a Master Word Template (via VBA) Windows 7 64bit Mailmerge Excel with a Master Word Template (via VBA) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
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

Quote:
Originally Posted by stevenel View Post
Initially, it is an Excel file. Before I merge, I save it as a csv file because there are too many mergefields (more than 255) in my original Merge Excel File. If I save it as xslm, Word cannot merge it because it stops at 255 mergefields. That's why I save it as csv and merge. Is there a solution?
In that case, instead of:
strWorkbookName = ThisWorkbook.FullName
you should be populating strWorkbookName with whatever the name of your CSV file is. For example:
strWorkbookName = Split(ThisWorkbook.FullName,".xls")(0) & ".CSV"
Simply closing & reopening the workbook won't give you access to the additional fields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge Excel with a Master Word Template (via VBA) Suppress blank lines in mailmerge of excel reports into word document beefcake2000 Mail Merge 1 11-10-2017 12:54 PM
Master template and subtemplate docs ab-os Word 1 05-02-2017 01:23 PM
Mailmerge Excel with a Master Word Template (via VBA) Template From MailMerge Document LouGibson Mail Merge 1 06-13-2016 03:14 PM
how to copy addresses in word document to excel/mailmerge list msnarayanan Mail Merge 4 10-17-2015 03:17 PM
Mailmerge Excel with a Master Word Template (via VBA) Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:26 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