• Retrieve details of active email using Outlook VBA

    I'm trying to retrieve details of an Outlook email that is either currently selected or opened through VBA. I can't find any details on how to do it. Thank you very much!

    ITKE354,365 pointsBadges:
  • Outlook email doesn’t send when computer is locked

    I've recently been having issues with sending Outlook emails using Excel VBA. I already have my code to do it, Sendupdate, and it's working fine when it's manually run. I also have an automatic timer that's intended to execute the same email at a specific time. But when the computer is locked, it...

    ITKE354,365 pointsBadges:
  • How to I check if sent messages were replied to yet in Outlook?

    For the most part, I send out a ton of emails and I often forget which ones get replied too. Would there be a way to use a VBA script to look at all the sent messages from the past week and check to see if they were replied? I know a bit about Excel VBA but I'm not sure if this is possible. Thanks!

    ITKE354,365 pointsBadges:
  • Why does recordset field lose decimals?

    I am reading a defined query as a recordset in a VBA module. I calculate a result such as 0.323 but when I set the recordset field (!ROR = tempROR) where tempROR has the decimals, the !ROR field acts like an integer. In the query the ROR field is defined as number with 3 decimals.

    itkegbs20 pointsBadges:
  • New to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box (course...

    Oistins2610 pointsBadges:
  • Where is my VBA code stored in Microsoft Outlook?

    I currently have a VBA project in Microsoft Outlook that has several email macros. After I recently had a PC crash so they all disappeared and now all I see is this 'Project1' on my computer. I don't have the time to code them again so is there anyway to rescue this?

    ITKE354,365 pointsBadges:
  • How to expand the treeview from that live URL using VBA macro?

    I have a live URL there its JavaScript function is there. There no input field and div field for that treeview, please can any one help me how to expand this treeview using VBA macro. I am new to VBA macro. Thanks in advance. It's urgent.

    sunitapanigrahy10 pointsBadges:
  • VBA Exporting to text file

    I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

    Dozii35 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • Macro toolbar buttons

    What format are macro toolbar buttons and how do I use them?

    Bumblbee10 pointsBadges:
  • Configure Microsoft Outlook to require a subject in outgoing emails

    Can I configure Microsoft Outlook so that it requires a subject in outgoing emails? When I use Outlook, I keep getting messages with empty subjects. Should I use a VBA to do this?

    ITKE354,365 pointsBadges:
  • MS Access Tools References

    Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

    Rjwilcox45 pointsBadges:
  • Insert record through VBA into a Access table

    I get a duplicate index error message when I insert a record through VBA into a table. The table has nearly 1345 records. The same code had worked fine earlier and also works fine now with a blank copy of the same table. I understand that it is not an issue with the code or the data inserted. Can...

    SuderKody20 pointsBadges:
  • Link Outlook Calendar to Excel Spreadsheet

    Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...

    Yosiniro5 pointsBadges:
  • PDF save as TXT file (VBA)

    Hi experts, I want to save a text file from PDF file through VBA (XLS) coding. I want to get the data as text mode from a specific PDF file in Excel Spreadsheet. Thanks, Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Convert Excel file to AS400

    I have 'n' number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files to be converted into...

    SKapoor0 pointsBadges:
  • Web Scrapping in VBA

    How to use getelementsbyclassname and getelementsbyid in web scrapping by VBA?

    shivu639815 pointsBadges:
  • MySQL CrossTab Query

    MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

    Carbon0 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following