Jon Ricoh

Dmiller, Here is some code for you to be able to call a certain sheet in an excel file. var xdf = new ExternalDataFileEx("data.xls", "Excel", "Sheet 2");

Drew, Sorry, that you didn't get a good experience with FusionPro Support. This would be something they would have to task to one of their programmers. You could use a text rule like this with 2 text frames and it should what I think you want. Put this rule in Frame A and then link it to Frame B. //Rule_info var myinfo = ""; //Creating an array to see how many fields are being used. //You can swop out any of these with the rules with the prefix text ("Direct: ", "Cell: ", "Main: ", or "NMLS #") var allinfo = [Field("Street Address"),Field("City State ZIP"),Field("Direct"),Field("Cell"),Field("Main"),Field("Email"),Field("Website"),Field("NMLS")]; //This is the tagged markup for the right justified text with a leading of 9pt var rightjust = '<p style="(no style)" override="true" quad="R" leading="90" findent="0" lindent="0" rindent="0" leadbefore="0" leadafter="0" keeplines="true" widows="1" kerning="true" hyphenate="false" skipifempty="true" skipifemptyvar="false" noparabreakoncopyfit="false"><tracking newsize="0"><f name="ITC Avant Garde Std Bk"><z newsize="7.0"><color name="C=0 M=100 Y=0 K=0">'; //This is the tagged markup for the left justified text with a leading of 9pt var leftjust = '<p style="(no style)" override="true" quad="L" leading="90" findent="0" lindent="0" rindent="0" leadbefore="0" leadafter="0" keeplines="true" widows="1" kerning="true" hyphenate="false" skipifempty="true" skipifemptyvar="false" noparabreakoncopyfit="false"><tracking newsize="0"><f name="ITC Avant Garde Std Bk"><z newsize="7.0"><color name="C=0 M=100 Y=0 K=0">'; //This is the loop to pull everything in for (i=0; i<allinfo.length; i++) { if (i<5) var mysep = rightjust+'<p>'; //This sets the right justification for the first 5 fields else var mysep = leftjust+'<p>'; //This sets the left justification for the rest if (i < 1) myinfo = AppendText(myinfo, "", rightjust + allinfo[i]); //set the right justification for the first field else myinfo = AppendText(myinfo, mysep, allinfo[i]); } return myinfo; //You can put this in the Javascript Globals so you can use it in all rules. function AppendText(FullText, Delimiter, NewText) { if (NewText != "") { if (FullText != "") FullText += Delimiter; FullText += NewText; } return FullText; }