Macro to break files and save with a specific word in the document.

**adil.master** · 03-10-2014, 08:46 AM

I am performing a Mail Merge with Word 2007 and Excel 2007 where the excel has multiple records which creates a huge word document.

The number of pages of each document can vary depending upon the increase and decrease of paragraphs hence i thought of adding a special character at the end of each document which would help us find the end of 1 document.

I am trying to search a macro that can break the word document into multiple documents by identifying a special character eg. "@/&/@/&" and then save each document with the invoice number thats available in the document.

Can someone please help me find a suitable code with explanation....

Your time is appreciated.

Regards,
Adi.

**macropod** · 03-10-2014, 09:04 AM

You could, of course, drive the process with a macro that saves each record as a separate file... For example:

Please Login or Register  to view this content.

The above code assumes your datasource contains fields named "Last_Name" & "First_Name" and saves the output with those names in whatever folder you select. You can, of course, choose whatever field(s) you like for the filenames - or even just a counter.

**adil.master** · 03-22-2014, 02:45 PM

Hi Paul,

Thank you for your time. Being a begginer in Macros I had a few queries...

- Do I need to enter this Macro in MS Word Module or MS Excel Module?
- Do I need to run the macro post the mail merge is completed?

Your time is appreciated.
Regards.

**macropod** · 03-22-2014, 04:37 PM

It's a Word macro and it runs the merge (i.e. you use it instead of the merge 'Finish' process).Your mailmerge main document still needs all the normal mailmerge setup, though.

Macro to break files and save with a specific word in the document.

LinkBack

Thread Tools

Rate This Thread

Display

Macro to break files and save with a specific word in the document.

Re: Macro to break files and save with a specific word in the document.

Re: Macro to break files and save with a specific word in the document.

Re: Macro to break files and save with a specific word in the document.

Thread Information

Users Browsing this Thread

Similar Threads

Trying to save a Mail Merge word Document to a specific folder

How to save word document on Sharepoint - VBA macro

Macro to save multiple files from list to specific location, with cell specific file name

help creating a macro in excel that opens a specific word document

[SOLVED] Open a specific Word document from an Excel Macro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions