Sending a questionaire back to uk

Narpal

New Member
Joined
Oct 6, 2006
Messages
3
I have put a button on a questionaire that is sent out to people all over Europe, (On my PC:Excel 2002, Windows 2000).
Behind this button there is a macro asigned, when clicked it will attach the questionaire sheet to an email, add my email address in the To box, and put in a subject, ready for any eurpoean to send the complete qustionaire back to me.
But although it works fine in the UK, it presents an error in Germany and probably will do in other countries also.
The error is: Run-time error '1004': Show method dialog class failed.

How do I overcome this so that it works no matter where from, using Lotus Notes.

The code used is:
Sub Macro4()
'
'To attach file to email, insert name and subject then close excel
Sheets("Survey").Copy
Application.Dialogs(xlDialogSendMail).Show "my.email@address.com", "Attached - Completed Survey", True
'xlDialogSendMail recipients, subject, return_receipt
ThisWorkbook.Save
ActiveWorkbook.Close SaveChanges:=False
Application.Quit
End Sub

Has anyone please got any idea. :eek:
Narpal
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
You might want to try
thisworkbook.sendmail ToPerson, Subject
instead of the dialog.
I believe it works with the native email system, although I only work with exchange, so I could be wrong. Might be worth a try though.

HTH
Cal
 

Forum statistics

Threads
1,141,070
Messages
5,704,112
Members
421,327
Latest member
Msh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top