VBA in Access or Outlook - Which one to use?

[Susan]

I have a table containing email addresses and other data that I need to email
out to each recipient in the table. Each email will contain in the body of
the message only the data relative to the particular recipient.
My question is which application Access or Outlook is the best one to code
the module in to do this?

I am using Access 2003 and Outlook 2003.

 

[Dennis]

Use the SendObject command in Access VBA.

 

[Arvin Meyer [MVP]]

Here's a way to use both Access to gather the data and Outlook to email it:

http://www.datastrat.com/Code/OutlookEmail.txt

 

[Andrei Smolin [Add-in Express]]

Also, see "Disable Outlook security warnings when sending email messages in
MS Access" at
http://www.add-in-express.com/creat...ty-warnings-sending-email-messages-in-access/.

Regards from Belarus,

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com

 

[Susan]

Thanks all, I coded it in Access, it works great. Now I just need to get rid
of that pesky security dialog box, but I saw some posts about that and will
check it out.

- Side note- Arvin the code you referenced is similiar to what I have, but I
needed to get the results of a query into the body, not an attachment.

 

[Arvin Meyer [MVP]]

I use Redemption which works with the Outlook client. I've never had a bit
of trouble with it, and nothing extra to code:

http://www.dimastr.com/redemption/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com