Anyone subscribe to Access*VB*SQL Advisor?

[perrymans]

I just went to pick up the April 2003 issue for the You've Got Mail article and they have moved on to May already! It is an article on how to send emails using Outlook from Access.

Thanks. Sean.

 

[grnzbra]

I just subscribed, so I didn't see it. Are you looking for some super duper way to do it or are you trying to find out how to do it?

 

[roverturf]

Sending an email from Access via Outlook is really easy. Make a cmdButton on your form and add the following code to the button's OnClick event:

Private Sub cmdEmail_Click()

DoCmd.SendObject acSendReport, "rptInventory", acFormatHTML, "sombody@yourcompany.com", , , _
"Inventory Report", "To: Somebody, Please see attached inventory report."

End Sub

-Richard

 

[perrymans]

grnzba,

I wanted to see that article again so that I could see what and hoe they were sending emails. Do you get the web access as well with your subscription?

RichardOverturf,

Thanks for the info, but I am not actually sending objects from Outlook, which complicates things more. I want to send out a mass email(s) based on the results of a query. I have something that works right now [thanks to thread javascriptpenindex(450,350,'

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350')

], but I wanted to fill the Bcc field for one email, rather than multiple singles if possible. Also, they know what they are doing, so I figure their coding will be more solid and robust.

Thanks. Sean.