Emailing from multiple contacts to PrintBoss

SUGGESTED

Anyone had any experience/success passing more than one email address from Sage 300's new Multiple Contacts module to PrintBoss? I assume we'd assign the email addresses in a subreport. Concatenating and delimiting the would be tricky, unless PrintBoss accepts email addresses assigned by row... Which I doubt.

  • 0

    What would stop you from concatenating the email addresses into a single field on the report via a sub-report?  You'll likely have to use variables and three formulas (e.g.  email_init, email_append, email_show) but once set up it is fairly clean.

    On the PrintBoss side, I wouldn't be surprised if they didn't have a mechanism for handling that. In the past when I've had what I thought was odd request of PrintBoss I typically find out that it is in the software, just not documented.  So it might be worth a call to them.

  • 0
    SUGGESTED

    Create a Contacts subreport in the Crystal form, with a formula on the detail row in the subreport.  Formula will be:

    shared stringvar altcontact;

    if onfirstrecord then altcontact :={XLCUSCT.EMAIL} else
    altcontact :=altcontact+';'+{XLCUSCT.EMAIL};
    ''

    Then enter the top line of the formula as the value of PrintBossMisc

    In PrintBoss, #Assign EmailTo, {DocMisc}

    You can also use DocMisc2 if you want.

  • 0

    Thanks, Django and Jim.

    Yes, I created a subreport with shared variable. I'll detail how I did it for OE Invoices, for those who want to play along.

    The subreport has ARCUSCF joining MTCONC on IDCONTACT.

    Subreport selection formula (for OE Invoices) is like so:

    {ARCUSCF.IDAPP} = "OE"
    and {ARCUSCF.IDFORM} = 2
    and {ARCUSCF.IDCUST} = {?Pm-OEINPR3.CUSTOMER}

    Formula in the details of the subreport:

    shared stringvar Emails;
    if onfirstrecord then Emails := trim({MTCONC.EMAIL}) else
    if trim({MTCONC.EMAIL}) <> "" then
    Emails :=Emails + ';' + trim({MTCONC.EMAIL});

    And a formula in the report footer to display the variable:

    shared stringvar Emails;
    "PB#Assign EmailTo, " & Emails;