Adjusting Email Preferences in Access

[Commander Dave]

I'm really getting the feeling Access doesn't want to be used for emailing people...

As a relational database, I would think email should be a much simpler task.

Access uses Outlook as it's email client, which is great - I love Outlook.

My Outlook is set to use one email as it's default, and one default Signature file. However when emails are sent from Access, it ignores these defaults. I have to manually change the FROM address, and I have to manually add the SIGNATURE file.

Is there a setting somewhere to change this? I haven't found it.

Using Access and Outlook 2010.

 

[boblarson]

I'm really getting the feeling Access doesn't want to be used for emailing people...

As a relational database, I would think email should be a much simpler task.

Not really.

Access uses Outlook as it's email client,

Not true. Access can use any email client but it is more tightly integrated with Outlook because it is another Office Application, although it isn't that integrated.

My Outlook is set to use one email as it's default, and one default Signature file. However when emails are sent from Access, it ignores these defaults. I have to manually change the FROM address, and I have to manually add the SIGNATURE file.

Is there a setting somewhere to change this? I haven't found it.

Nope, because just like any other Office program it is totally independent and isn't that tightly integrated. It is integrated in that you can use COM to connect with and manipulate things, just like you can to Word, Excel, PowerPoint, Publisher, Project, Visio, etc. But there are some things that you just have to do which are outside the purveyance of the program.

 

[Commander Dave]

Sorry Bob

I wasn't killing Access if thats how my post was received. I just remember using an older version with things being much simpler to do.

To wrap this post up, it seems as if you are saying that these Email Preferences I referred to can not be adjusted in Access. Is this correct?

 

[boblarson]

To wrap this post up, it seems as if you are saying that these Email Preferences I referred to can not be adjusted in Access. Is this correct?

Correct. If you want the signature and such you have to go about it using a text file and pulling that in using code when you build the email in the code and using the Outlook object.