Search results for query: *

I humbly apologize that I was not specific in my original post. And I can’t get my code to work either. In the template there is %user% embedded in the text and that text I want to replace and if it work a pieces of other text too. I’ve used this code and the template pops up in Outlook but the...

Yes - and I have found some code at the internet (the lifeline besides Tek-Tips :)) hope that I can modify it for my purpose. Have a nice weekend.

Works but the embedded images in the original body are lost.

Mintjulep thanks for your answer – but the templates body already has a text and what I want is to insert text into it. Your suggestion erases the text in the body and replaces it with – Whatever :)

Is it possible to put some text at the top of the body in a fetched template via VBA code? The main body of the template is sent to different users with a text at the top of the body that differs (a text string that have a number of variables from textboxes in the user form. I hope that you...

Andy –I would appreciate any code to solve this ”problem”! Christer

Then my users will have to take the disadvantage to press Allow to send the message. Thanks for the answer. Christer

I’ve made a program in Excel that sends e-mail in Outlook (2010) after the user has put same information in a user form. This Is not a problem but I get this annoying message – “another program Is trying to send an e-mail etc.” Allow – Deny – Help. I’ve searched for help but I haven’t found...

Combo - Life is simple when you know how to code yourself through it. Thanks ever so much - that code works perfectly. CluelessChris – what I ment was that I’ve got several drafts whit instructions that I send to different people every day. I want to send the draft and keep it in the same time...

I’ve searched the web and found the following code to send a draft and the code works fine. But with one exception – the draft is sent and removed from the drafts folder. Is it possible to modify the code so the draft is sent and kept for recycling? The content of the draft is sent several times...

Thanks for the advise - but I'am trying to figure out how to solve it using some VBA-code to open a previosly saved draft and then hang on code for recipient etc and send it. The code is in a Word-document. Christer

If I save a mail as a draft how can I reuse it thats what I ment.

The code for recipients and attachments is finished but how to open a previously saved mail I can’t figure out. I’ve looked around and have not found anything useful. Thanks beforehand Christer

That is possible if you have a visual basic licence on your computer witch I have not. Other suggestions? Mollethewizard

Is it possible to use the mxmask32.ocx located in windows\system32 on a user form? If it is, how can I do it? Happy weekend to you all Mollethewizard

I suppose this is really simple, but, how can I read data from an ini-file to a variable in Excel? The ini-file is situated in C:\USER and is named User.ini. It has a section [Employee] with Name=Sven Svensson Let’s say I would like to read Name and put it in a variable X. In Word I use...

Chance Talking of idiotic questions…. ThisWorkbook.Close savechanges:= False Did the trick regardless how many other workbooks there were open. Thanks for putting me on the right track! Mollethewizard

This maybe very simple – but anyway – I’ve got a workbook with a modeless user form with a button that closes this particular workbook. Code goes like this: Application.ActiveWorkbook.Close Savechanges:=False That’s all right providing the workbook is activated. Is there a simple way to assign...

I’ve got a user form with several text boxes in it that the user puts Swedish currency values in like this – 123,55 – as you probably know we use commas as decimal sign in Sweden. The values are passed to a sheet and then if something is wrong and the user wishes to alter the “input” the values...

Thanks a million! Works like a dream! Mollethewizard