Search results

Right sorted that out, now i get 'compile error' sub or funtion not defined on line

but now i get a 'compiler error' (expected sub, functon, or property) on the line

Nice Gasman, Nice! thanks for your reply (-:

Hi Guy's I have this code working however only if Outlook is open. I know that I need to create a On Error Handler and some VBA to open Outlook when it's not running. Can anyone please help or point me in the right direction. Many thanks:D

Hi Guys i have tried this. but i get a compile error sub or function not defined. on thi line - Call writeTemplate(filesPath)

Ultamitly the database will be set on a shared network and then the Template.msg will be set in each users documents

I'm trying this but not working..

What i need is a the file path for and desk top user. Hope you can help.

Thanks guy's ive sorted it, cheers for your help

Hi Guy's How do i add an attach file to this piece of code.:D:D

Sorry forgot to say I've sorted it out and everything is in working order, thank you so much for your help and patients. Kind regards,

It comes up with 'compiler error' label not defined on the error handler line.

works fine thank you. I just need to set the path to any user I've tried just not woking

Is this correct because it's not working? Or am I missing something

ideally I want the path set to any desktop, any 'User' and set the font text and size? with also 'Dear' before txtContactName? Thanks for all your help so far

And how do I set the font text and size? with also 'Dear' before txtContactName?

Sorted it out, it now opens up in edit mode, still need to VBA 'Environ' ?

It now opens the word application but not to the 'Template.docx'

Do I call that from a modal or does it sit under click command? doc.ReadOnly = False 'compile error' can't assign read-only property? Thanks for your help.

Does anyone know how to set this to 'Environ' I want to set the path to any desktop. And also set it to edit and not read only? Help much appreciated :D