Stack Overflow
Stack Overflow

Questions tagged [office-automation]

Use this tag for questions related to automating MS Office Products ( Excel, Outlook, PowerPoint, Access, Word, Project, etc. ). Automation in this context means the use of an external software, not an MS Office product, to execute a variety of operations on MS Office products. For questions about macros use the relevant tags for example "excel" and "vba". Do not use this tag if your question is not about automatic control.

Automation in this context means the use of computer systems to execute a variety of operations such as word processing, spreadsheet calculation, database manipulation, etc. without user interruption.

If you have a specific programming question about Excel or Word (or any other product from the MS Office package) and it is not about automating it via external software then use tags like , , , etc.

805 questions
-1
votes
1 answer

Outlook Folder with MSG Files, transfer to a CSV

I have a folder with 200ish msg files from Outlook which I need to put in a single CSV where each column represents one msg with corresponding subject, body, to etc. Any good idea how to do that without doing it manually?
eskay
  • 23
  • 3
-1
votes
3 answers

Edit Outlook locally saved .msg body by replacing text in VBA

Good afternoon, I have an Outlook .msg email saved at a local folder in my computer. Is there any way I can replace the word "AAAA" in the body with any word I want in VBA? Is there any way I can change the To: field? The goal is to run an Excel…
mikizas
  • 331
  • 5
  • 16
-1
votes
1 answer

Find and replace or copy and paste from excel to word

I'm trying do generate some files docx of data from excel to word. I'm just learning the basic of VBA, so I lasted a few hours to find this a find and replace logical. But at the time I tried with a lot of text, more than 255 characteres it's not…
Rogério Bonorino
  • 1
-1
votes
1 answer

Adding macro button to trigger a specific Macro

Whenever I add a custom Macro button to the Quick Access Toolbar , it is a generic Macro window invocation button. What I want is that if I click on the button, a specific Macro should directly start running. As of now there are 2-3 steps before I…
Dhiraj
  • 3,396
  • 4
  • 41
  • 80
-1
votes
1 answer

How do you send an email that has already been filled out in Outlook using any script?

I need to send an email through outlook that already has all the details filled in (eg. subject, body, etc), except it has to be done through some sort of script. This can be any script that works on Windows 10. Essentially, all I need the script to…
Agent 3 6 9
  • 11
  • 3
-1
votes
1 answer

I am trying to download email attachment from outlook in C#. its working with visual studio but not working when i am hosting to windows service/IIS

//This below line has some issue but i am unable to find the issue can anyone help me out or provide some alternate option to download the attachment //outlookNamespace.GetDefaultFolder(OlDefaultFolders.olFolderInbox) Application outlookApplication…
S Rahman
  • 1
  • 1
-1
votes
1 answer

Signature not showing up in outlook after creating macro in excel

I have been trying to create an automailer in excel but the signature does not come up when I try to send it out. This is the VB script: Sub Send_email_fromexcel() Dim OApp As Outlook.Application, outlookmailitem As Outlook.MailItem, signature…
daguy57
  • 1
-1
votes
1 answer

Why ASP.NET Web App works well when run the .exe from cmd but throws an error from IIS?

It's about ASP.NET Web App that doing simple Visio Office Automation- convert file from vsdx to svg. I already know thet it's not recommended to do it on server side from the Microsoft documantation MS. But, only Visio convert my complicated…
Gal Tzemach1
  • 41
  • 6
-1
votes
1 answer

Is it possible to automate Visio using a third party?

We are trying to create a Visio project file and to process it with an external tool to generate a json file that a web app can read to create a decision tree based on the json contents. We know about 3rd parties to automate MS Word files but no…
Ignacio Soler Garcia
  • 21,122
  • 31
  • 128
  • 207
-1
votes
1 answer

How to insert an image in an excel page header using delphi?

I'm trying to figure out how can I insert an image into an excel page header using delphi. I've seen how I can do it into a normal cell but not into the page header. Anybody can help? Thanks.
Nuno
  • 81
  • 2
  • 7
-1
votes
1 answer

How can I generate the white space in the end of the Paragraphe in Docx Using C# code?

I want to create a document and auto fill it using C# program, however, I have to fill the white space in the end of each paragraphe for Eg: let's say this is my paragraphe > John Albert is a famous singer, he used to sing Rap songs even when he…
Feelbad Soussi Wolfgun DZ
  • 75
  • 1
  • 3
-1
votes
2 answers

How to compare 2 excel sheet column values

I have 2 Excel sheets (using Excel 2007) Excel sheet1 with column names name kumar manu kiran anu Excel sheet2 with column names name kumar anu I will upload the sheets and then I click on a button (here I will compare the …
happysmile
  • 7,537
  • 36
  • 105
  • 181
-1
votes
1 answer

Calling Access sub from Outlook - Method Run of Object _Application failed

I'm trying to run a subroutine in MS Access when an email is received in Outlook. I'm using an Access.Application object and its Run method. I get the following error: Method Run of Object _Application failed. Private Sub Application_newmail() …
bsg
  • 825
  • 2
  • 14
  • 34
-2
votes
2 answers

Binary of the latest Qt framework (with MingW32) working out-of-the-box for COM/ActiveX programming

Can someone point to me where I can find binary distribution of the latest Qt Framework 4.8.0. (with MingW32) ready for Office automation?
menjaraz
  • 7,551
  • 4
  • 41
  • 81
-2
votes
1 answer

After Updating to Windows 11 getting compiler error from Microsoft Interop.Office ASP.NET WebForms

after updating to WINDOWS 11 getting silly error from Compiler (Compiler do not want compile line which contains Microsoft.Interop.Word). But before update everything worked just fine (I mean on Windows 10 ) . Is someone get same error . Thank you…
FarHard112
  • 35
  • 4
1 2 3
…
53
54