Send Object from Form

[khashid via AccessMonster.com]

hi, I have read all threads regarding my issue but couldnt find exactly what
I want.

Actually I have a form, i want to email the data from that form to different
addresses depending on which address user chooses from ComboBox.

So what I want is :

User fills the form (form has 8 different fields that need to be sent), then
chooses email address from combo box named "Email". The information will be
sent as soon user clicks the button "SEND".

Now I managed to send the Form information as text inside the outlook, but I
want to have sent the information as attachment in Doc format. Doc name
should be field used in the form [CC_No].

I want to send the information as soon user clicks send, do not want the
option to edit the message.

Your help will be appreciated.

 

[Guest]

One solution would be to have a report based on the info in the report,
export it to word to produce your doc, then send the email with the
attachment.

In all cases, using outlook automation or sendobject you, the programmer,
choose whether or not the user interacts with the email before sending it.
If they dont need to you make the whole process transparent. That is your
choice! The sendobject has a parameter (the last one I think) which controls
this aspect.

Sources of info:
I would suggest you google this one, there is tons of email coding already
out there.
Lookup sendObject in the VBE Help.

Also check out,
http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx