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
-2
votes
1 answer

Ways to automate Outlook Application

After every patching we test basic Outlook functionality like able to send email etc, wanted to check if there is any way to automate the Outlook UI.
Kalava
  • 231
  • 2
  • 4
  • 18
-2
votes
2 answers

Reading text file and sending mails to outlook using Python

I am reading .txt file in Python code and I should get the same mail body what I have in my text file. It is working fine but hyperlinks not displayed in my outlook email, it displays only as text in outlook email. Below is the code: Mail_Content =…
Shruthi
  • 1
  • 2
-2
votes
1 answer

Python Win32com Want to copy specific line from body part to excel

I'm trying to copy a specific line from the mail body but I don't know how to do that. I thought regex could solve my problem but didn't know how to implement it again. mail body: Line1 line2 line3 line4 …
Rohan -
  • 1
  • 1
-2
votes
1 answer

Validate the receiving email has attachment

Want to validate the receving email has attachment Set outObj= CreateObject("outlook.Application") Set outAccount = outObj.Session.Accounts.item(1) Set nameSpace = outObj.GetNameSpace("MAPI") Set myFolder = outAccount.Session.GetDefaultFolder(6) Set…
Waqas Qayyum
  • 1
  • 2
-2
votes
1 answer

Creating complex Office 365 documents in VS Code

I have a web application that creates complex Office documents in Excel, Word, and PowerPoint; and I need to convert the application from Visual Studio to Visual Studio Code. The previous application uses the Microsoft Office Interoperability…
Ken Paul
  • 5,685
  • 2
  • 30
  • 33
-2
votes
1 answer

vba offset with reference to cell

I need to copy a column of data to another column on a different worksheet, pasting values only. The appropriate paste column is identified in a single cell. This cell will be changed manually each time the macro is applied. So one time I might…
Michael Price
  • 1
-2
votes
1 answer

I want to automate general office admin tasks

I want to automate general office admin tasks at work am looking into using Python as my programming language. I am new to coding and understand basics but need guidance. I am proficient at using most me office programs and know sql but want to…
Raul Lemus
  • 3
  • 3
-2
votes
1 answer

convert HTML to word format

I use word automation to create a word document. I want to embed some html code in that file. how should I cnvert html tags to word document format? ( I want to keep font, bold, table and other styles in html)
mjyazdani
  • 2,110
  • 6
  • 33
  • 64
-4
votes
1 answer

Construct Outlook Tasks and E-Mail Invites using C#

Our software supports using C# for scripting purposes. We can add Using and Assembly references to the software interface. Our software can send HTML Body Mails or normal E-Mails. The scenario as follows: A scheduled task on the server runs over…
NA_AbuAdam
  • 5
  • 2
-6
votes
1 answer

Error HRESULT E_FAIL has been returned from a call to a COM component

i am getting above exception for line of code below: System.Net.WebClient wc = new System.Net.WebClient(); byte[] data = wc.DownloadData(xmlTempNode.Attributes["imageurl"].Value.ToString()); MemoryStream ms = new MemoryStream(data); …
Milind Anantwar
  • 81,290
  • 25
  • 94
  • 125
1 2 3
…
53
54