A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Split a mail merge document into individual documents



 
 
Thread Tools Display Modes
  #11  
Old October 1st, 2009, 09:31 PM posted to microsoft.public.word.mailmerge.fields
Samy
external usenet poster
 
Posts: 11
Default Split a mail merge document into individual documents

Hi
I am not very technically inclined but I can generally help myself but I am
currently stumped. I have tried to make the change to the macro as described
below and I keep getting a message that the project is unviewable. I am
using Office 2007. The add-in works very well but instead of a single page
document I have three pages. Please help...

"Doug Robbins - Word MVP" wrote:

In place of the

Documents.Add

command in the macro, use

Documents.Add Template:="C:\Program Files\Microsoft Office" _
& "\Templates\Memos\Professional Memo.dot"replacing 'C:\Program
Files\Microsoft Office" _
& "\Templates\Memos\Professional Memo.dot"

With the name of the template used to create the mail merge main document.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Shelly Faye" wrote in message
...
Thank you for your "splitmergeletter" macro - it really helps - except for
one thing - formatting is coorect when I merge to new doc - it changes the
font only when I execute your macro??!!

Why?

The original letter is in Arial, the resulting letters are in Arial, the
split letters are in Times New Roman - and as there is a specific look on
the
page - eg letterhead also in Arial, we want to preserve the original look.

Thank you for your help.

"Graham Mayor" wrote:

See http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




leedelee wrote:
How do I take a mail merge document and then split it up into
individual documents to save each letter in a separate place?






  #12  
Old October 2nd, 2009, 10:18 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Split a mail merge document into individual documents

You will need to use FileOpen, and then navigate to the Word Startup folder
and open the template that contains the code. Then while you have the
template open, you will be able to access the code in it to make the change.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Samy" wrote in message
...
Hi
I am not very technically inclined but I can generally help myself but I
am
currently stumped. I have tried to make the change to the macro as
described
below and I keep getting a message that the project is unviewable. I am
using Office 2007. The add-in works very well but instead of a single
page
document I have three pages. Please help...

"Doug Robbins - Word MVP" wrote:

In place of the

Documents.Add

command in the macro, use

Documents.Add Template:="C:\Program Files\Microsoft Office" _
& "\Templates\Memos\Professional Memo.dot"replacing 'C:\Program
Files\Microsoft Office" _
& "\Templates\Memos\Professional Memo.dot"

With the name of the template used to create the mail merge main
document.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Shelly Faye" wrote in message
...
Thank you for your "splitmergeletter" macro - it really helps - except
for
one thing - formatting is coorect when I merge to new doc - it changes
the
font only when I execute your macro??!!

Why?

The original letter is in Arial, the resulting letters are in Arial,
the
split letters are in Times New Roman - and as there is a specific look
on
the
page - eg letterhead also in Arial, we want to preserve the original
look.

Thank you for your help.

"Graham Mayor" wrote:

See http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




leedelee wrote:
How do I take a mail merge document and then split it up into
individual documents to save each letter in a separate place?







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge to Labels BK Publisher 15 March 16th, 2006 03:44 PM
mail merge to individual document (file) Bails Publisher 1 January 29th, 2006 02:28 PM
only one page of mail merge document is printing dkilventon General Discussion 0 November 22nd, 2005 06:15 PM
Mail Merge from Outlook Creates 2 Documents Guy Lapierre General Discussion 6 November 10th, 2005 10:07 PM
Mail merge - how to stop SQL msg on merged docs J_Gold New Users 1 May 10th, 2005 05:04 AM


All times are GMT +1. The time now is 12:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.