Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel Sheet Formatting when we use SO_NEW_DOCUMENT_ATT_SEND_API1

Former Member

‎2010 Aug 16 12:34 PM

0 Likes
629

Hi,

I need to schedule a background job which sends an email with excel sheet attachment to the group of users.

I have used the FM:SO_NEW_DOCUMENT_ATT_SEND_API1 for this. Now my client asks me to format the column headers(BOLD with SOme background color) and asks me to adjust the column width .

Please advise how to achieve this?. We can do this in forground,but I need this in background.

Hi,

I need to schedule a background job which sends an email with excel sheet attachment to the group of users.

I have used the FM:SO_NEW_DOCUMENT_ATT_SEND_API1 for this. Now my client asks me to format the column headers(BOLD with SOme background color) and asks me to adjust the column width .

Please advise how to achieve this?. We can do this in forground,but I need this in background.

Reply
2 REPLIES 2
Read only

former_member201275
Active Contributor

‎2010 Aug 16 12:55 PM

0 Likes
502

this should help:

Read only

Former Member

‎2010 Aug 16 2:10 PM

0 Likes
502

Hi Gemini,

I have written the code for sending the mails with excel attachments.

OLE will not work when we run the program in background since it requires front end services.

Please advise how to format the colums headers when we use the SO_NEW_DOCUMENT_ATT_SEND_API1 FM for sending the mail?.