Hello Ross,
Welcome to Microsoft Newsgroup Support Service!
From your post, my understanding on this issue is: You wonder why the email
message sent by Excel Automation has an additional line "FAQ 600 600¡*"
before the "Introduction" line in Blackberries. If I'm off base, please
feel free to let me know.
From my point of view, there can be two possible reasons for the issue:
1. Workbook / Excel specific problem. i.e. something's wrong with the
Workbook or Selection we grabbed to send.
2. Blackberry specific problem. i.e. Blackberry does not interpret Excel's
XML format correctly, and results in the additional line.
In order to narrow down our focus, let's verify the above guesses:
The KB article "How to send a range of cells in an e-mail message by using
Visual Basic for Applications in Excel"
http://support.microsoft.com/kb/816644
introduces the standard way to send a range of cells in Excel. We can
create a new workbook, input some simple text into A1:B5 (e.g. "aa", "bb"),
then copy & paste the VBA code in the KB article to the workbook's
VBAProject (ALT+F11), run it and see if Blackberry displays the spreadsheet
correctly. If you still get an additional line in Blackberry, it is very
likely that Blackberry does not interpret Excel's XML format correctly. And
I'd suggest you contact Blackberry support for further assistance
(
https://www.blackberry.com/CSOHelp/)
To see the HTML source sent by Excel, we can open the email in Outlook,
right click on the introduction line, and select "View Source" command. The
resulting html should contain something like:
<div id=cover-sheetThis is the introduction line.
<hr
This part of HTML is for the introduction line. You can check the HTML
source before this part, and see if there is anything like "FAQ 600 600¡*".
If you are not comfortable with HTML, please send the HTML source to my
mailbox ), and I will check it for you. It will be
helpful if you can send the workbook to me too. Honestly, I do not have
Blackberry at hand, but I will do my best to help you from other angles of
the issue.
Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
.
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.