Send Object....

[ukgthor]

I want to set up a macro to run a query, open a report and send the report in a pdf format to an extrenal user.

I have written the macro, however I have two issues:

1. When I run the macro, I get a messge from MS Outlook stating that an application is trying to send an e-mail on my behalf and gives me an action to allow or deny - how can I prevent this message happening ?

2. I want to include some specific text in the body of the e-mail I send, however there doesn't seem to be a way to format the text in regard to bold, underline or even carriage returns etc.

All help appreciated.

I'm currently using MS Office 2007.

 

[darbid]

1. When I run the macro, I get a messge from MS Outlook stating that an application is trying to send an e-mail on my behalf and gives me an action to allow or deny - how can I prevent this message happening ?

This is a FAQ. This link explains this Microsoft problem and gives solutions http://www.outlookcode.com/article.aspx?ID=52

2. I want to include some specific text in the body of the e-mail I send, however there doesn't seem to be a way to format the text in regard to bold, underline or even carriage returns etc.

I do not use the sendobject but I am pretty sure you cannot format your email. You would have to use the outlook object model. There are many examples on this here in this forum and on the net.