E-mailing and inporting data

[Guest]

I have tried to find the answers to these in previous threads but got a bit
lost sorry. Can anyone help me:-

1) Want a macro button on a form to be able to send a preditermined e-mail
to one of the fields on the form, so one field will be owner and it will be
the e-mail address for someone, click the button e-mail wizzes off.

2) Import data from an excel sheet, someone fills the excel sheet in, can
this be merged into access automatically, would it have to be done manually.

Thanks again anyone who can help

Matt

 

[Ron2006]

1) Here is one way for the email

Set o = CreateObject("Outlook.Application")
Set m = o.CreateItem(0)


m.To = me.fieldnameofemailaddress
' m.cc = for copies

' m.bcc = for blind copies

m.Subject = "Defect Analysis for " & Forms![fieldname]

m.body = "now is the time"

m.send ' to send it instead of displaying it.
' m.Display ' use this to display the email instead of
sending
' ' the user will need to send it then.

set o = nothing
set m= nothing

2) look up help on transferspreadsheet
On this I would advise importing to a separate local table and then
runnning an append query to append the imported records into their
proper table.

Ron

 

[Guest]

Thanks Ron, I'll give that a try