Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with '&Profiles.' command in the GM word template field list 1

Status
Not open for further replies.

Hap007

MIS
Mar 21, 2003
1,018
US
The '&Profile.(s) field list from the GMLink.dot seems to take additional parameters.

Does anyone have information on this field and the parameters that are available?

Currently, if I insert @Profiles in a word document, it will return all email addresses in the 'Contact Tab', additional contacts. What I would like to retrieve is the additional Contact Name and Title.

Any help or a place to look for documentation on this field would be greatly appreciated.

Thanks,
Hap..

Access Developer [pc] - [americanflag]
Specializing in Access based Add-on Solutions for the Developer
 
Hap,

&Profile(s)

Two related macros:
&Profile: returns the first matching profile record for the selected contact.
&Profiles: returns all detail records for the selected contact.
Both of these macros take optional parameters. Each parameter must be separated by a period (.). Although GoldMine does not typically pass parameters with a DDE macro, the structure of &Profiles must be different for DDE fields in Microsoft Word document templates, which do not take DDE commands.

The following examples show the syntax for the &Profile(s) macros:
&Profile Example 1
&Profile.ProfileName.Reference.Flags
Retrieves the first profile that matches the ProfilleName and Reference.
&Profiles Example 1
&Profiles.ProfileName.Reference.Flags
Retrieves all profiles that match the ProfileName and Reference.
In both of the above examples, the Reference parameter is optional. If passed, the Reference parameter acts as a "begin with" condition on the profile reference. If the Reference parameter is not passed, all ProfileName profiles are evaluated.

The optional Flags parameter is also optional. The Flags parameter has the following values:

2 returns the extended profile fields
4 returns the ProfileName and Reference
The &Profile(s) macro can easily fill in a Word table with the selected contact’s profile information because tabs separate each field value, and a CR/LF separates each profile record.
&Profile Example 2
The following example returns the first e-mail address of the contact:
&Profile.E-mail Address
&Profiles Example 2
The following example returns all the computer profiles that begin with the word notebook:
&Profiles.Computer.Notebook

&Profile Example 3
The following examples use the Flag parameter to specify the profile fields to return:
&Profiles.Computer.Notebook
Notebook ThinkPad 770|
Notebook Compaq Elite|
Notebook Dell 1200|

&Profiles.Computer.Notebook.2
Computer|Notebook ThinkPad 770|
Computer|Notebook Compaq Elite|
Computer|Notebook Dell 1200||

&Profiles.Computer.Notebook.4
Computer|Notebook ThinkPad 770|IBM|233Mz|
Computer|Notebook Compaq Elite|Compaq|200mz|
Computer|Notebook Dell 1200|Dell|166mz|


Regards,

Richard.
PRIOR Analytics UK
 
Richard,

Thanks for taking the time to respond.

The information you provided is what I currently have available to me in the GoldMine Documentation that I printed from the FrontRange Soultions Knowledge Base.

The only two commands that work from the above example, when placed in a Word document are:

&Profile. Which returns the first non blank additional contact email address and

&Profiles. Which returns all non blank additional contact email addresses.

Any other examples from your description(Which is also available on the FrontRange Solutions web site) do not work.

I also called FrontRange Tech support, and they do not know how to make the other examples work in a word document.

FrontRange told me that the additional parameters must be a mistake in the documentation, but I do not think so.

Any way, I am looking to find out how to pass reference and flag values.

What I need returned is Title and Contact name for all additional contacts.

Thanks,
Hap...


Access Developer [pc] - [americanflag]
Specializing in Access based Add-on Solutions for the Developer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top