DB Emailing Questions

[axm0035 via AccessMonster.com]

1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give
me an idea of how the code will be like.
2) Also can i assign the email to have a recipient automatically or do i have
to write it down each time?

Thank you in advance.

 

[Piet Linden]

1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give
me an idea of how the code will be like.
2) Also can i assign the email to have a recipient automatically or do i have
to write it down each time?

Thank you in advance.

SendObject doesn't let you do anything beyond sending a simple e-
mail. If you want to automate formatting (basically have any control
over your formatting), you need to automate Outlook. There are
examples all over the place.

 

[Gina Whipp]

axm0035,

Not with SindObject. Have a look at these...

http://www.candace-tripp.com/Pages/SearchResults.aspx?query=outlook

http://www.devhut.net/index.php?lang=en&id=0000000007

http://www.granite.ab.ca/access/email/outlook.htm

http://www.blueclaw-db.com/access_email_send_outlook.htm

Code to sent Multiple eMails:
http://www.datastrat.com/Code/MultipleEmail.txt

Download sample database EmalSenate2K (PLEASE do not send eMail from this
database to the eMails shown. This is for demonstration purposes only!):
http://www.datastrat.com/DataStrat2.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[axm0035 via AccessMonster.com]

Thank you.

1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give

[quoted text clipped - 6 lines]
SendObject doesn't let you do anything beyond sending a simple e-
mail. If you want to automate formatting (basically have any control
over your formatting), you need to automate Outlook. There are
examples all over the place.

 

[axm0035 via AccessMonster.com]

Thank you.

axm0035,

Not with SindObject. Have a look at these...

http://www.candace-tripp.com/Pages/SearchResults.aspx?query=outlook

http://www.devhut.net/index.php?lang=en&id=0000000007

http://www.granite.ab.ca/access/email/outlook.htm

http://www.blueclaw-db.com/access_email_send_outlook.htm

Code to sent Multiple eMails:
http://www.datastrat.com/Code/MultipleEmail.txt

Download sample database EmalSenate2K (PLEASE do not send eMail from this
database to the eMails shown. This is for demonstration purposes only!):
http://www.datastrat.com/DataStrat2.html

1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please

[quoted text clipped - 5 lines]

Thank you in advance.