SendObject action - auto insert of email address | Access forum

Resolved · High Priority · Version 2007

Fri 25 Mar 2011, 11:27 Edited on Mon 28 Mar 2011, 10:09 Delegate Andy said...

Andy has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access Advanced course

SendObject action - auto insert of email address

Update 28/3/11
Hi again

If worked out how to put an email address in to the 'To' field - insert the expression =[Field name].
However, I now can't find a way of adding more than one email address to the 'To' i.e. we have up to 5 email addresses per Supplier so I may want to send to them all.

At the moment I'm going to utilise the CC and BCC fields so I can send to 3 email addresses but would like the ability to send to more recipients.

Any ideas?

Thanks
Andy

Hi
I'm setting up a process to compile and send reports by email.
I have built an event using SendObject that selects the records for a supplier from a query and transfers it to a report, and attaches it to an email with standard subject line and body text.
However, the sendobject command won't allow me to automatically insert the supplier's email address in to the "To" field in the email.

the process would be much slicker if i could get access to add the email address to the email rather than copying and pasting the email address from the access form.

Are there any solutions?

Thu 31 Mar 2011, 08:51 Trainer Anthony said...

RE: SendObject action - auto insert of email address

Hi Andy, thanks for your query. Two things about this. First I would concatenate the email addresses in one string and bolt that into the address field of the email. You could pull the emails into a list box and allow the user to select which ones to use.

Secondly, and this is without knowing the nature your database, you may need to loop through however may email addresses you have at some stage. That will involve some code I'm afraid.

Hope this helps,

Anthony

Wed 6 Apr 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.