I have an automatic text that I send out and all works fine except for the text gets broken into 2 pages.
example of text that gets sent
1 of 2
FRM:Anson Golf Club
SUBJ:Flights
MSG:Times-Flights
1:30 Champ 62-65
1:30 First 66-67
1:30 Second 68-71
8:00 Third 72-73
8:00
(Con't) 2 of 2
Fourth 74-75
8:00 Fight 76-83
(End)
All information is perfect, but I would like to get rid of the "1 of 2" and the "(Con't) 2 of 2" so that the "Fourth 74-75" would be on correct line.
Below is my expression
dim t as p
t = table.open("cell")
dim pm as P
pm.attachments = ""
pm.lrelated = .T.
pm.from = "[email protected]"
pm.from_alias = "Golf Club"
pm.to = "golfers"
pm.subject = "Flights"
pm.message = "Times-Flights"\
+crlf(1)+tbl.champ+" ""Champ "+tablemin("tourney","Current='Y'.and.Flight='Championship'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Championship'",str("satscore"))\
+crlf(1)+tbl.First+" "+"First "+tablemin("tourney","Current='Y'.and.Flight='First'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='First'",str("satscore"))\
+crlf(1)+tbl.Second+" "+"Second "+tablemin("tourney","Current='Y'.and.Flight='Second'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Second'",str("satscore"))\
+crlf(1)+tbl.third+" "+"Third "+tablemin("tourney","Current='Y'.and.Flight='Third'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Third'",str("satscore"))\
+crlf(1)+tbl.Fourth+" "+"Fourth "+tablemin("tourney","Current='Y'.and.Flight='Fourth'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Fourth'",str("satscore"))\
+crlf(1)+tbl.Fifth+" "+"Fifth "+tablemin("tourney","Current='Y'.and.Flight='Fifth'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Fifth'",str("satscore"))\
email_send2(pm)
Thanks, Tony
example of text that gets sent
1 of 2
FRM:Anson Golf Club
SUBJ:Flights
MSG:Times-Flights
1:30 Champ 62-65
1:30 First 66-67
1:30 Second 68-71
8:00 Third 72-73
8:00
(Con't) 2 of 2
Fourth 74-75
8:00 Fight 76-83
(End)
All information is perfect, but I would like to get rid of the "1 of 2" and the "(Con't) 2 of 2" so that the "Fourth 74-75" would be on correct line.
Below is my expression
dim t as p
t = table.open("cell")
dim pm as P
pm.attachments = ""
pm.lrelated = .T.
pm.from = "[email protected]"
pm.from_alias = "Golf Club"
pm.to = "golfers"
pm.subject = "Flights"
pm.message = "Times-Flights"\
+crlf(1)+tbl.champ+" ""Champ "+tablemin("tourney","Current='Y'.and.Flight='Championship'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Championship'",str("satscore"))\
+crlf(1)+tbl.First+" "+"First "+tablemin("tourney","Current='Y'.and.Flight='First'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='First'",str("satscore"))\
+crlf(1)+tbl.Second+" "+"Second "+tablemin("tourney","Current='Y'.and.Flight='Second'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Second'",str("satscore"))\
+crlf(1)+tbl.third+" "+"Third "+tablemin("tourney","Current='Y'.and.Flight='Third'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Third'",str("satscore"))\
+crlf(1)+tbl.Fourth+" "+"Fourth "+tablemin("tourney","Current='Y'.and.Flight='Fourth'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Fourth'",str("satscore"))\
+crlf(1)+tbl.Fifth+" "+"Fifth "+tablemin("tourney","Current='Y'.and.Flight='Fifth'",str("satscore"))+"-"+tablemax("tourney","Current='Y'.and.Flight='Fifth'",str("satscore"))\
email_send2(pm)
Thanks, Tony
Comment