biscuittech
Technical User
Hello all,
I'm trying to do the following:
Use contact info entered in a form that has first name, last name, email address (hyperlinked or formatted as mailto: if necessary) to:
1. open Outlook
2. Create a new message with a report from access attached
3. fill in the email address
the catch is that it would need to be general enough to be used on any contact in the db.
I've sort of figured out the individual parts using Microsoft's copy_clipboard VBA script (which is a little over my head) and the built in email functions. But this seems a little too clunky to be correct and requires an awkward paste at the end.
Does anyone have a better way?
Thanks in advance.
David
I'm trying to do the following:
Use contact info entered in a form that has first name, last name, email address (hyperlinked or formatted as mailto: if necessary) to:
1. open Outlook
2. Create a new message with a report from access attached
3. fill in the email address
the catch is that it would need to be general enough to be used on any contact in the db.
I've sort of figured out the individual parts using Microsoft's copy_clipboard VBA script (which is a little over my head) and the built in email functions. But this seems a little too clunky to be correct and requires an awkward paste at the end.
Does anyone have a better way?
Thanks in advance.
David