Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nospace in setting in word up mail merge
Message
From
05/03/2012 20:38:47
 
 
To
05/03/2012 13:37:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01537250
Message ID:
01537352
Views:
45
following your example below i have come up with this - it actually passes through without errors this time around. However it does not affect the line spacing as i had hoped. do i need to define the span of pragraphs(1) or is it default for the whole document - which is what i want. btw this is not mail merge - i am simply creating a formated letter which when selected will contain the client name and other details.
#DEFINE wdToggle 9999998
#DEFINE wdLineSpaceSingle 0

LOCAL loWord, loSelection, loDocument
loWord = CREATEOBJECT("Word.Application")
loWord.Visible = .T.
loDocument = loWord.Documents.Add()
loSelection = loWord.Selection
loSelection.Font.Name= "CALIBRI"
loSelection.Font.Size= 11 

	with loselection.Paragraphs[1].format 
	 .LineSpacingRule = wdLineSpaceSingle
	endwith

_cliptext=FILETOSTR("temp.txt")
loSelection.paste()
>Glad the paper's helping you. You might also be interested in the book Della Martin and I wrote on automating Office from VFP: http://www.hentzenwerke.com/catalog/autofox.htm
>
>For this problem, as I said, the Line object isn't what you think it is, and it's not relevant. Take a look at the LineSpacing property of the Paragraph object.
>
>Tamar
>
>>btw tamar - i am going through your article as we speak - nicely done - thanks - k
>>could this be related to a #define .... i wonder - i have been trying to solve it through loSelection.
>>
>>http://www.tomorrowssolutionsllc.com/Materials/AutomatingWord.html
>>
>>
>>>>I am try to get vfp to print up some form letters using mail merge - i've go this far but can't seem to change the line spacing when the document opens in Word - default is 1 line - i would like it set to 'nospace' so the signature will appear uninterrupted.
>>>>
>>>>i took a guess at the code - checked some sources but can't seem to find any reference to this feature. any ideas??
>>>>
>>>>(Apologies that i cannot credit the pro who got me this far - this code has little to do with me.) many thanks k
>>>>
>>>>
>>>>#DEFINE wdToggle 9999998
>>>>LOCAL loWord, loSelection, loDocument
>>>>loWord = CREATEOBJECT("Word.Application")
>>>>loWord.Visible = .T.
>>>>loDocument = loWord.Documents.Add()
>>>>loSelection = loWord.Selection
>>>>loSelection.Font.Name= "CALIBRI"
>>>>loSelection.Font.Size= "10.5"
>>>>
>>>>loSelection.line.nospace  &&& XXX does not work
>>>>
>>>>_cliptext=FILETOSTR("temp.txt")
>>>>loSelection.paste()
>>>>
>>>
>>>The Word Line object isn't what you think it is. The line spacing you're talking about is related to the Paragraph object. Check out Paragraph.LineSpacing.
>>>
>>>Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform