Spacing of Attachments

[Joe Adams]

I am developing some automation components in Excel to
send workbooks via Outlook. I create the body of the
message (via .Body "xxx xxx") and then attach
(via .Attachment filename) from one up to one hundred
workbook attachments. I would like to organize the
attachments into rows of 5 attachments, insert a carrage
return - line feed and a tab, the next five attachments
and so on.

How would I do this in VBA??

Thanks for your help,

Joe

I am using Excel 2000 and Outlook 2000 (SR-2s) on Windows
2000 Professional.

 

[Ken Slovak - [MVP - Outlook]]

You can't. The position of an attachment is based on the format of the
email. HTML, plain text and RTF all position attachments differently.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm

 

[Sue Mosher [MVP]]

Do you know with 100% certainly that the recipient is using OUtlook?
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm