Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Ms Access to Outlook

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access class microsoft training - Ms Access to Outlook

Resolved · Low Priority · Version Standard

Reply Tue 17 Jul 2007, 14:32Delegate Reza said...

Reza has attended:
Excel Advanced course

Ms Access to Outlook

MsAccess has two-toolbar button for emailing reports/tables and other stuff via Outlook.

Button 1) Mail as attachment
Button 2) Mail Recipient *

Unfortunately, Button 2 * is not highlighted in almost all possible default toolbars, customs. How can we make it highlighted so we can send email file directly NOT as a attachments. Or any other solutions exist to resolve the issue?

Thanx

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Aug 2007, 12:30Trainer Carlos said...

RE: Ms Access to Outlook

Hi Reza

The reason the button is NOT active is that the only way you can email Access objects is as Attachments.

To send a report as the body of an email you would need to convert it to Word and then send it.

Regards

Carlos

Reply Wed 8 Aug 2007, 13:00Delegate Reza said...

RE: Ms Access to Outlook

Hi Carol,

I have already tried that suggested way but I was after to send entire body of the report from Access.
Also I have another question, when I creat the form in MsWord and attach it to email as a body, my Check boxes, drop boxes are NOT showing in reciepient email.

Thank you

Access articles

· Use Split Form View In Access For Simultaneous Views
· User-Level Security In Access
· How To Take Control Of Your Data And Save Money In The Process
· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Mistakes to Avoid

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips