Replies

Phil,

Does Word only allow you to assign a hyperlink to a toolbar button? or, can you assign it to a command button on a form?

Thanks.

I have put the code into a custom form, similar to what Hans suggested. But my problem is how to distribute this form to other people. Do you know of another way (Apart from creating a COM Add-in) ,to distribute a custom form in Outlook without overwriting the vbaproject.otm file?

Also, if I do have to create a COM Add-in, how do I link it to the SEND event in Outlook?

I am also wondering how to determine what type of item caused the send event. Is there a way to determine if it was a mailitem, or appointmentitem etc?

Thanks.

(Edited by HansV on 22-Jul-03 01:51. Added reference to Outlook thread.)

Hello. I am creating my first COM Add-in for Microsoft Outlook 2002. I want my module to be triggered whenever the SEND button is pressed in Outlook. How do I cause this to occur?

Note by HansV: This question is a sequel to post 276113 in the Outlook forum. Outlook has only one file in which VBA can be stored, so something else is needed to distribute code.

Hans,

Many thanks – that worked. Now I need to know how to save and distribute the code.
The template with the code is saved as
C:DOCUMENTS and SETTINGSAPPLICATION DATAMICROSOFTOUTLOOKvbaproject.otm.

Is it possible to save it to another location? with another name? In Word, there is a startup folder, is there something like this in Outlook?

Thanks.

I am using the controls in Word and in Access. It was a free download from the website and included controls such as the Richtext box, treeview, listview etc..

Hans,

I finally found the problem in the first statement. It was in the name of the field “Work”. For some reason, this isn’t acceptable. When I renamed it to “txtWork”, then all was okay.

It took me 2 days to figure it out! But I appreciate your input.

Marie-Therese

Hans,
None of the text fields contain double quotes. However, now I am getting a syntax error (missing operator) on the first record! The SQL statement is:

INSERT INTO HEADER (IFACE, RUNDATE, COMPANY, COMPANYNO) VALUES (“”Field 1″”, “”12-MAY-2003″”, “”Value 3″”, “”92661124436″”)

Hans,

I am importing a large text file into a database to make a simple report. I am treating everything as text.
The reason I didn’t want to use single quotes is because some of the text fields have single quotes in them. Is there a way around this?

Thanks

Thanks Hans. At least now I know I am not going crazy, and that my computer isn’t broken.

Yes I am using the Quick Launch toolbar to open Excel many times. You are quite right, Excel is show multiple times in the Processes tab.

However, it doesn’t work like this for Word. I can click Word on the Quick Launch toolbar many times, and it only shows it once in the Taskbar, and once in the Processes tab. It would be great if Excel could work the same way.

Thank you! That worked!

Thank you!

Thanks Hieronymous, that has been most helpful.

Gary,

Thanks for this help. I removed all the references to the global templates and saved the template. Then I added the references back to the global templates, and now the error seems to have disappeared.

Marie-Therese

Many thanks!