AnsweredAssumed Answered

email body adding portal fields

Question asked by pmcgihon on Feb 20, 2009
Latest reply on Mar 11, 2009 by pmcgihon

Title

email body adding portal fields

Post

Having problems with pulling related data into email body from portal records.

So far have all fields from main table in email and looks fine.  Trying to line up using List() for fields from portal. Results look like following:

 

Invest Date               Invest Amount             Project

6/16/2005       

8/15/2005                 1350000

622931           Ridge at Orchard Hills

 

How do I get the data fields to line up across under the headers and include all data even if data is same as record 1.  It should look like:

Invest Date               Invest Amount             Project

6/16/2005                  1350000                  Ridge at Orchard Hills

8/15/2005                    622931                  Ridge at Orchard Hills

 

My code is following:

"¶¶"  & "Invest Date            Invest Amount                Project " & "¶"  & List( IRG Invest Amounts::INVEST_DT)  &  "       "  & List( IRG Invest Amounts::INVAMT)  & "           "& List(IRG LLC::LLC_DESC)

 

Yes, I will be attempting to format the invest amount.  One step at a time.

Thanks in advance for your help with my problem.

Phyllis McGihon

Outcomes