did you try with different e-mail address' (your sure the other 2 are spelled correctly).
Follow these steps so you can convert the Macro to VBA so we can check the snytax.
with the macro window selected, select the Send macro (but don't open it), go to tools/Macro/Convert Macro to Visual basic)..click convert
The VB window will open, look in the top left window (Project list) Look for "converted Macro...." (with your Macro name)...copy/paste the text to this post....
Should look like...
'------------------------------------------------------------
' send
'
'------------------------------------------------------------
Function send()
On Error GoTo send_Err
DoCmd.SendObject acQuery, "qryTableRef", "MicrosoftExcelBiff8(*.xls)", "ziggy", "", "", "", "", False, ""
send_Exit:
Exit Function
send_Err:
MsgBox Error$
Resume send_Exit
End Function
