John-
When I use SendReportHTML function, I found that all the comma "," are not displayed in the email body. For example:
In the report: Unbound txtbox HotelAddress
=[HotelName] & ", " & [HotelAddress] & ", " & [HotelPostcode] & " " & [City] & "," & [Country]
All these comma are not displayed in the html mail body. Please help. Thanks in advance.
Best Regards,
Kevin
Date: 2015-11-08 21:18
Subject: Re: Re: [MS_AccessPros] Send specific report with SendReportHTML function
John-
I didn't put code in the report. I just forgot to format the text.
I got the line showed in the html email just now. I added "*^*" in both begining and end of the text... It works. Thanks a lot!
Best Regards,
Kevin
Date: 2015-11-08 21:13
Subject: Re: [MS_AccessPros] Send specific report with SendReportHTML function
Kevin-
I don't see where lines would have appeared in what you sent.
You said earlier that you managed to get formatting back. What code did you use when you got the formatting you want?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
John-
No, that character is the title means "THE FIRST",it's part of the report.
Best Regards,
Kevin
发自我的小米手机
在 "John Viescas
JohnV@msn.com [MS_Access_Professionals]" <
MS_Access_Professionals@yahoogroups.com>，2015年11月8日 下午8:40写道：
Kevin-
I don't understand what I'm seeing here. Are you sending a snippet of code as the HTML body?
Perhaps this: 第一章
.. is the line generated on a Chinese machine?
If that's the case, then you need to do:
' Replace lines
strHTML = Replace(strHTML, "第一章", "<hr>")
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
John-
The text below is the output html in email. You see there's table line.
Best Regards,
Kevin
| If IsNull(Me.GroupBookingID) Then |
| Forms!frmGroupBooking!subPart. |
| Forms!frmGroupBooking!subPartService. |
| Forms!frmGroupBooking!subPartItinerary. |
| Forms!frmGroupBooking!subPartItineraryCityTour. |
| Forms!frmGroupBooking!subPartItineraryCityTourDayService. |
| Forms!frmGroupBooking!subPartItineraryCityTourSpot. |
| Forms!frmGroupBooking!subPart. |
| Forms!frmGroupBooking!subPartService. |
| Forms!frmGroupBooking!subPartItinerary. |
| Forms!frmGroupBooking!subPartItineraryCityTour. |
| Forms!frmGroupBooking!subPartItineraryCityTourDayService. |
| Forms!frmGroupBooking!subPartItineraryCityTourSpot. |
Tidak ada komentar:
Posting Komentar