P
Peter Hibbs
Access 2003 & Mozilla Thunderbird.
I am trying to write some code to send an email from within Access
where the user has Mozilla Thunderbird program as their email client
software. I am using code which is taken from their Web site at :-
http://kb.mozillazine.org/Command_line_arguments_(Thunderbird)
The code I am using looks like this :-
vInLine = " -compose to=" & strRecipients & ",subject=" &
strSubject & ",body=" & strBody & ",attachment=" & vAttachments
Call Shell(vEMailExecutable & vInLine, vbMaximizedFocus)
where vLine, strRecipients, strSubject, strBody and vAttachments are
String variables that hold the relevant information and
vEMailExecutable holds the full path and filename of the Thunderbird
executable program. The variable vAttachments holds the path and
filename of a .pdf file on disk.
Unfortunately, I don't have this program on my own PC so I am relying
on my client to tell me what happens, and is as follows -
When the code is executed the Thunderbird program runs OK – shows the
email and the attachment (as “C:\Folder\File.pdf”, without the quotes)
– they click Send and Thunderbird hangs showing a progress bar
indicating that a signature is being generated.
If they click Cancel, remove the attachment, click attach from within
Thunderbird and navigate to the file (above) and click OK, the file
appears in the attach window as “File.pdf” (no quotes), click Send –
progress bar shows activity, signature added and email gets sent OK.
Does anyone have any idea why it should hang and is there any changes
I should make to the code that would fix the problem.
Peter Hibbs.
I am trying to write some code to send an email from within Access
where the user has Mozilla Thunderbird program as their email client
software. I am using code which is taken from their Web site at :-
http://kb.mozillazine.org/Command_line_arguments_(Thunderbird)
The code I am using looks like this :-
vInLine = " -compose to=" & strRecipients & ",subject=" &
strSubject & ",body=" & strBody & ",attachment=" & vAttachments
Call Shell(vEMailExecutable & vInLine, vbMaximizedFocus)
where vLine, strRecipients, strSubject, strBody and vAttachments are
String variables that hold the relevant information and
vEMailExecutable holds the full path and filename of the Thunderbird
executable program. The variable vAttachments holds the path and
filename of a .pdf file on disk.
Unfortunately, I don't have this program on my own PC so I am relying
on my client to tell me what happens, and is as follows -
When the code is executed the Thunderbird program runs OK – shows the
email and the attachment (as “C:\Folder\File.pdf”, without the quotes)
– they click Send and Thunderbird hangs showing a progress bar
indicating that a signature is being generated.
If they click Cancel, remove the attachment, click attach from within
Thunderbird and navigate to the file (above) and click OK, the file
appears in the attach window as “File.pdf” (no quotes), click Send –
progress bar shows activity, signature added and email gets sent OK.
Does anyone have any idea why it should hang and is there any changes
I should make to the code that would fix the problem.
Peter Hibbs.