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

microsoft.office.interop.word replace table text inside shape

I'm using microsoft.office.interop.word to replace( table cells text ) and I'm keeping this table inside shape, I'm trying to replace the text which is inside this table but the Problem when replacing is done the Table Format is removing and…
user9470241
-1
votes
2 answers

How to trigger Python script when sending an Outlook email?

I would like to trigger a Python script when I send an email through Outlook. So far I have only seen solutions to trigger a Python script when an email is received but not when sending an email.
ronmakh
  • 29
  • 6
-1
votes
1 answer

How can I change the default font of Outlook 2016?

I want to change the default Arial Font type to Montserrat in Microsoft Office (not the 365). I'm following what is presented here and here. I was also told that I should try running it in PowerShell but I have no idea how. The following is what I…
Hallow_Worlds
  • 7
  • 2
-1
votes
1 answer

Mass email with personalized content

I know it's not 100% related to coding, but there is plenty of knowledgeable folks here, someone may know the answer. I need to send a mass email (270 recipients) and each email needs to contain a pull from Excel sheet, containing data related to…
Lukasz Cegielski
  • 1
-1
votes
1 answer

Extract specific data in Outlook emails to Excel s/sheet

Good evening all, I have an Excel Macro I am trying to make work and also adapt slightly. There are 3 issues I need to fix: My code throws up a Compile Error: "End if without block if". I am a beginner and don't know what this means? I need to…
Brendan Ramsey
  • 23
  • 5
-1
votes
2 answers

Excel Macro modification required to pull data from multiple Word docs and to address RUN TIME ERROR CODE '4605'

I already have a Macro in Excel that pulls through data from specific tables, rows and columns in a specified Word doc and returns it to cells in my Excel s/sheet. I need to make 2 alterations to the code but my knowledge is not advanced enough. I…
Brendan Ramsey
  • 23
  • 5
-1
votes
1 answer

Is VB.NET really better than C# for Office Interop?

While looking for an example how to open an Excel file with Excel Interop I stumbled upon this answer where the author writes the following under a piece of code that uses the Workbooks.Open method: [..], this stuff is much easier if you use…
t3chb0t
  • 16,340
  • 13
  • 78
  • 118
-1
votes
1 answer

How to prevent Excel from appearing and disappearing?

No matter what language, every time I use the Excel object, I have this problem. Say I'm running a loop, opening & closing workbooks. The visible property on the Application class is set to false. If I open an Excel file from the file system…
medic
  • 37
  • 8
-1
votes
1 answer

How to Delete Outlook Item in Archive.pst

I'm stucked, i'm able to connect a pst file in Outlook, I would like to loop through all folders / search a certain email with a certain subject and then, delete it. I've searched through the web but don't know how to start, can someone explain me…
Pax212fr
  • 9
  • 2
-1
votes
1 answer

Send an Outlook mail to both people in a dictionary with Python 3

I try to send 3 emails,through outlook, to 3 different people (with python 3) that contain pdf file attached. In key 12 I have 2 values, so when i run it while "secNum" variable is 12, the code send the email only to test2@gmail.com and not to…
newGIS
  • 598
  • 3
  • 10
  • 26
-1
votes
1 answer

Missing maills from Outlook when exporting by VBA

i am using VBA Excel to exporting tables from body code works fine till today I found so missing mails such as I have 18 mails at 5-Sep but code get only two mails , i exporting from send items even if i try export from Inbox first mail received…
Ebram Shehata
  • 33
  • 5
-1
votes
2 answers

Python: How to get my own emailadress from Outlook?

I try to get the users emailadress from outlook with python but i allways get this Error: File "C:\Users\me\Documents\Coding\Python_Projects\TEST\mainLogin.py", line 76, in __init__ self.myAdress = self.outlook.Session.CurrentUser.Address …
Robert
  • 159
  • 1
  • 9
-1
votes
2 answers

How can I extract and use the value from a Word rich text content control in Outlook VBA?

I want to print a number of pages which depends on the number filled in in a Word content control. I tried referring to the object with this: Set objCC = xFileName.SelectContentControlsByTag("q_179").Item(1) Total = objCC Counter = 0 …
Bryan
  • 1
  • 3
-1
votes
2 answers

open Outlook in mode new Mail in ASP.NET Core

i'm developping an ASP.NET Core project with Angular as front-End. after a user creates an invoice, i want to open outlook in mode 'New mail' with the customer adrees mail prefilled and the invoice document attached. there is no problem in sending…
mohamed souilmi
  • 81
  • 1
  • 8
-1
votes
1 answer

Paste Outlook Table into Excel Worksheet using Interop in c# from background Thread

How do I 'copy / paste' an instance of an Microsoft.Office.Interop.Word.Table which has styling (Colors, Borders etc...) into an Excel Worksheet using the Microsoft PIA from a background thread in C#? It's relatively easily done from the UI thread…
AwkwardCoder
  • 24,893
  • 27
  • 82
  • 152
1 2 3
…
53 54