![]() |
|
#1
|
|||
|
|||
![]() 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? |
#2
|
||||
|
||||
![]() Quote:
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] |
![]() |
Tags |
mail merge, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |
![]() |
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |