Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word Automation question.
Message
From
15/01/2002 11:00:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00604396
Message ID:
00604847
Views:
23
Colin,
Assuming you do this with some kind of automation I'd first put mergefields there separated with commas, tabs or alike trimmed. Then converttexttotable.
Another way that comes to mind instead of mergefields having those in a separate dbf and InsertDatabase() operation at bookmarked location. It'd automatically create a table with the rowcount returned from query.
And yet another option is to walk through rows and delete empty rows (but with slow VBA automation I think I'd never take this one in a merged doc).
And another option is to send all that section as a trimmed, comma separated memo field and converttexttotable.
Cetin

>Cetin/Jay
>
>The table idea works great for the alignment, thanks. Table question for both of you then. When I had the mergefields as below, if, for example, the 3 and 4 fields were empty, the whole document would shift up 2 lines. With the mergefields now in a 4 row table, is there any way for the table to automatically shrink to 2 rows if the 3 and 4 fields are empty?
>
>>>This question is from the Word side of things as opposed to VFP but figured this group is the best to ask so:
>>>
>>>I have a comma and quote delimted text file for the mailmerge. The mailmerge fields need to be lined up in columns, so they are layed out like the following:
>>>
>>>
>>>Student          Grade          Fee
>>>student1         grade1         fee1
>>>student2         grade2         fee2
>>>student3         grade3         fee3
>>>student4         grade4         fee4
>>>
>>>
>>>The trouble is the grade and fee mergefield positions shift depending on the length of the student mergefield.
>>>
>>>Is there a way to ensure a mergefield takes up a certain amount of space, no more and no less, without padding the mergefield values and using a non-proportional font? The client has a font standard for all documentation so that is not an option.
>>
>>Colin,
>>Insert mergefields in a table or use tabs.
>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform