Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



VBAExpand / Collapse
Author
Message
Posted 8/21/2006 3:02:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 8/21/2006 3:28:47 PM
Posts: 2, Visits: 5
How do you refer to fields in Calyx using VBA?
Post #3818
Posted 3/14/2007 4:14:24 PM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242
You have to catch the MailMergeBeforeMerge event (a little tricky). Then you loop through the merge variables:

With Doc.MailMerge.DataSource
        For j = 1 To .DataFields.Count
            Debug.Print .DataFields(j).Name
            Debug.Print .DataFields(j).Value
        Next
End With

One trick is to place Point Field ID #7 as an invisible field (we use 1 point typesize with white foreground embedded in the header) in the document. Read in this value then use your own or a third-party routine to read the Point file directly. That way you have access to virtually all of the fields in the file rather than just the fields passed in the merge.

-Scott

- Mike
mike@mtig.biz

Post #4587
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Emmanuel Huna, Bryan Telford, Jason Beck, Mike Thompson, BetaFisch

PermissionsExpand / Collapse

All times are GMT -8:00, Time now is 1:09am

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.031. 10 queries. Compression Enabled.
© 2005 Calyx Software. All rights reserved.