ActiveWorkbook.SendMail truncating filename

  • Thread starter Thread starter Clayton Tucker
  • Start date Start date
C

Clayton Tucker

Good morning,

I have a situation where when I use the ActiveWorkbook.SendMail
function, it truncates the filename of the attached spreadsheet to an
8.3 format. Is there anything I can do to prevent this?

....
Workbooks.Open Filename:= _
"G:\path_to_files\Uninitialized SKUs.xls"
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveWorkbook.Save
ActiveWorkbook.SendMail
Recipients:=mergeArrays(Array(getSomePeople(), getMore People(),
getJML())), Subject:="Uninitialized SKUs"
ActiveWindow.Close
....

The workbook they recieve is named "Uninitia.xls". My environment is
MS Excel 2002 (10.5815.4219) SP-2 on WinXP SP1, Email client is Novell
GroupWise.

Thanks for your help
CT
 
Hi Clayton
The workbook they recieve is named "Uninitia.xls".
Click to expand...
I can't reproduce it in OE/Outlook

Sub test()
Workbooks.Open Filename:= _
"G:\path_to_files\Uninitialized SKUs.xls"
'ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveWorkbook.Save
ActiveWorkbook.SendMail "", "This is the Subject line"
End Sub
 
Hi Clayton,

Like Ron, I'm unable to replicate this using Outlook or OE. From what I've
seen on the web, it sounds like this may be a GroupWise limitation (maybe
fixed in a service pack).

http://support.novell.com/cgi-bin/search/searchtid.cgi?/2965453.htm

<quote>
The GroupWise client no longer truncates
attachment names on Windows XP.
</quote>

There are some other relevant articles, so try a search in Google or Google
Groups to see what you find.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Jake Marx said:
Hi Clayton,

Like Ron, I'm unable to replicate this using Outlook or OE. From what I've
seen on the web, it sounds like this may be a GroupWise limitation (maybe
fixed in a service pack).

http://support.novell.com/cgi-bin/search/searchtid.cgi?/2965453.htm

<quote>
The GroupWise client no longer truncates
attachment names on Windows XP.
</quote>
Click to expand...

Thank you Jake, that turned out to be the solution. The IT guy came
down today & patched me.

CT
 
Hi Clayton,

Clayton said:
Thank you Jake, that turned out to be the solution. The IT guy came
down today & patched me.
Click to expand...

No problem - I'm glad you got things sorted out!

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Jake Marx said:
Hi Clayton,



No problem - I'm glad you got things sorted out!
Click to expand...

Oh for Pete's sake.

The GroupDumb patch fixed the filename mangling problem, at the cost
of not attaching subject lines to the sent emails.

I just can not win.

Clayton Tucker
/me is heading off to go find a nice base64 encoder and CygWin
 
Back
Top