Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
Solved
vba code to split and save mail merged word document
Posted on 2014-02-14
Hi Experts word 2007
I need vba code to split and save mail merged word document into individual word doc and saved to a specific file path...based on company name as unique identifier..
Unable find the code on the net..also need instructions on hiw the code works for learning purposes.
I need vba code to split and save mail merged word document into individual word doc and saved to a specific file path...based on company name as unique identifier..
Unable find the code on the net..also need instructions on hiw the code works for learning purposes.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2- +1
8 Comments
Active today
There is some VBA code to do that in this question:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_23921133.html
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_23921133.html
Active today
In a letter-type of mail merge the result document is separated into sections, one per record in the datasource.
Here is the code with some comments added.
Here is the code with some comments added.
Sub SplitMergeResult()
'declare the variables
Dim sec As Section
Dim rng As Range
Dim strName As String
Dim DocA As Document
Dim DocB As Document
Set DocA = ActiveDocument 'make the actived ocument the source document
For Each sec In DocA.Sections 'step through each section
Set rng = sec.Range 'get the range of the section
rng.MoveEnd wdCharacter, -1 'omit section break
rng.Copy
strName = Split(sec.Range.Paragraphs(1).Range.Text, vbTab)(0) 'find the new name in the text. It might well be in a different place in your document
Set DocB = Documents.Add 'create a new blank document
DocB.Range.Paste 'paste the text from the current section
DocB.SaveAs strName & ".doc" 'save the new document and
DocB.Close 'close it
Next sec 'now treat the nest section
End Sub 'all done, so end the procedure
Active today
Hi,
You could use this code in you mail merge template document ( placed in the ThisDocument module )
it captures the mailmerge events
at line 37 replace the 1 of ".Item(1).Value" with the column number of the FirmID
at line 39 Change the filename and Path to your convenience
Close the file and reopen before doing the merge, The Wizard will appear and at the last step Click "Custom Letter Processing"
Regards
EE-20140214.zip
You could use this code in you mail merge template document ( placed in the ThisDocument module )
it captures the mailmerge events
Dim WithEvents wdapp As Application
Dim bCustomProcessing As Boolean
Private Sub Document_Open()
Set wdapp = Application
bCustomProcessing = False
ThisDocument.MailMerge.DataSource.ActiveRecord = 1
ThisDocument.MailMerge.ShowWizard 1
With ActiveDocument.MailMerge
If .MainDocumentType = wdFormLetters Then
.ShowSendToCustom = "Custom Letter Processing"
End If
End With
End Sub
Private Sub wdapp_MailMergeWizardSendToCustom(ByVal Doc As Document)
bCustomProcessing = True
Doc.MailMerge.Destination = wdSendToNewDocument
With Doc.MailMerge
For rec = 1 To .DataSource.RecordCount
.DataSource.ActiveRecord = rec
.DataSource.FirstRecord = rec
.DataSource.LastRecord = rec
.Execute
Next
End With
MsgBox "Merge Finished"
End Sub
Private Sub wdapp_MailMergeAfterMerge(ByVal Doc As Document, ByVal DocResult As Document)
If bCustomProcessing = True Then
With Doc.MailMerge.DataSource.DataFields
sFirmPathName = .Item(1).Value ' First Column of the data
End With
DocResult.SaveAs "c:\Documents\" & sFirmPathName & "\MailDocument.docx", wdFormatXMLDocument
DocResult.Close False
End If
End Sub
at line 37 replace the 1 of ".Item(1).Value" with the column number of the FirmID
at line 39 Change the filename and Path to your convenience
Close the file and reopen before doing the merge, The Wizard will appear and at the last step Click "Custom Letter Processing"
Regards
EE-20140214.zip
Hi experts
Can I run the vba via a button in the word document? If yes how what are the necessary steps...so I can learn.
Can I run the vba via a button in the word document? If yes how what are the necessary steps...so I can learn.
Active today
For my Code
First Activate the document containîng the mailmerge
Press Alt+F11 to go to the Visual Basic Editor.
Insert the code in the module ThisDocument int the Microsoft Word Objects of your file ( Not the Normal)
Click Ctrl+R to Toggle the Project Explorer
You wi8ll have to change the code to accomodate your need ( Change the path,, name of the document and so on)
then close the document and reopen it to make the macro work
Regards
First Activate the document containîng the mailmerge
Press Alt+F11 to go to the Visual Basic Editor.
Insert the code in the module ThisDocument int the Microsoft Word Objects of your file ( Not the Normal)
Click Ctrl+R to Toggle the Project Explorer
You wi8ll have to change the code to accomodate your need ( Change the path,, name of the document and so on)
then close the document and reopen it to make the macro work
Regards
Featured Post
The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon.
In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Shortcuts in Word
Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Suggested Courses
Course of the Month6 days, 18 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.