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  

Graham Mayor -- individual merge letters



 
 
Thread Tools Display Modes
  #21  
Old December 11th, 2006, 05:45 PM posted to microsoft.public.word.mailmerge.fields
zoolaw444
external usenet poster
 
Posts: 16
Default Graham Mayor -- individual merge letters

Thanks for the suggestion. I checked that and that doesn't seem to be the
issue. I wish it were that simple!
  #22  
Old December 11th, 2006, 06:22 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Graham Mayor -- individual merge letters

The only way to help you with this will be for you to send me the mailmerge
main document so that I can have a look at it.

--
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

"zoolaw444" wrote in message
...
Thanks for the suggestion. I checked that and that doesn't seem to be the
issue. I wish it were that simple!



  #23  
Old December 11th, 2006, 06:30 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Graham Mayor -- individual merge letters

I was just about to make the same suggestion as Doug :-)

Peter Jamieson
"zoolaw444" wrote in message
...
Thanks for the suggestion. I checked that and that doesn't seem to be the
issue. I wish it were that simple!



  #24  
Old December 11th, 2006, 09:07 PM posted to microsoft.public.word.mailmerge.fields
zoolaw444
external usenet poster
 
Posts: 16
Default Graham Mayor -- individual merge letters

Is that an option? If so, please provide me with contact info.
  #25  
Old December 12th, 2006, 04:44 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Graham Mayor -- individual merge letters

Remove the REMOVECAPS from my email address

--
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

"zoolaw444" wrote in message
...
Is that an option? If so, please provide me with contact info.



  #26  
Old December 12th, 2006, 08:23 PM posted to microsoft.public.word.mailmerge.fields
zoolaw444
external usenet poster
 
Posts: 16
Default Graham Mayor -- individual merge letters

Thanks! I emailed you the document at the address you provided.
  #27  
Old December 13th, 2006, 04:34 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Graham Mayor -- individual merge letters

I have not received it yet, could you check that you correctly de-spammed
the email address and send it again.

--
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

"zoolaw444" wrote in message
...
Thanks! I emailed you the document at the address you provided.



  #28  
Old December 13th, 2006, 02:44 PM posted to microsoft.public.word.mailmerge.fields
zoolaw444
external usenet poster
 
Posts: 16
Default Graham Mayor -- individual merge letters

I'm certain I did, but I resent it just in case.
  #29  
Old December 14th, 2006, 04:51 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Graham Mayor -- individual merge letters

For others following, this issue was resolved by having the user use the
following code. I have not analysed where it differs from what she was
using from Graham's website

' splitter Macro
' Macro created by Doug Robbins to save each letter created by a mailmerge
' as a separate file, retaining the header and footer information.
Dim i As Long, Source As Document, Target As Document, Letter As Range
Set Source = ActiveDocument
For i = 1 To Source.Sections.Count
Set Letter = Source.Sections(i).Range
Set Target = Documents.Add
Target.Range.FormattedText = Letter.FormattedText
Target.Sections(Target.Sections.Count).PageSetup.S ectionStart =
wdSectionContinuous
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i

--
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

"zoolaw444" wrote in message
...
I'm certain I did, but I resent it just in case.



  #30  
Old December 14th, 2006, 06:32 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Graham Mayor -- individual merge letters

It is actually nothing like the original code ... but it could be soon

--

Graham Mayor - Word MVP

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


Doug Robbins - Word MVP wrote:
For others following, this issue was resolved by having the user use
the following code. I have not analysed where it differs from what
she was using from Graham's website

' splitter Macro
' Macro created by Doug Robbins to save each letter created by a
mailmerge ' as a separate file, retaining the header and footer
information. Dim i As Long, Source As Document, Target As Document, Letter
As Range
Set Source = ActiveDocument
For i = 1 To Source.Sections.Count
Set Letter = Source.Sections(i).Range
Set Target = Documents.Add
Target.Range.FormattedText = Letter.FormattedText
Target.Sections(Target.Sections.Count).PageSetup.S ectionStart =
wdSectionContinuous
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i


"zoolaw444" wrote in message
...
I'm certain I did, but I resent it just in case.



 




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


All times are GMT +1. The time now is 05:48 PM.


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