Open Outlook and paste recipients

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I would like to add an action button to a form which opens up Outlook and
pastes a selection of e-mail addresses in the "To-filed". I have a query that
returns the selection of e-mail addresses I would like to use. Is there
anyone who knows how to do this? I’m very grateful for all help.

Best regards
Åsa Lindelöf
 
There are 2 ways of doing this depending on your needs.

1- Using the SendObject method (Look it up in the help, it has all the
details and an example).
2- Automating Outlook using access. More complexe but also more powerful as
you can pretty much do anything you can do in Outlook. For more info take a
look at http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

All things considered, you should look at the SendObject methond as it
should suit your need as described in your original post. Google "Access vba
sendobject" and you should get tons of examples.
 
Back
Top