Vba outlook macromunkák
SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...
Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.
Egy excel alapú bevételező, raktárkezelő és receptúrázó "alkalmazást" kellene Accessre ültetni, nemi fejlesztéssel (vélhetően Form és VB macro)
Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti
Helló! Cégünknek van egy letölthető excel megrendelőlapja. Ennek a macro funkcióit kéne helyrerakni (pl: küldés, üres sorok törlése stb) Szeretnék egy könnyen használható, biztonságos megrendelőlapot egy-két macro funkcióval és felhasználóbarát külsővel. Mellékeltem az excel fájlt, ebből kéne kiindulni. Köszi Gergő
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...
I'm looking for an experienced 3D artist who can create realistic, high-quality renderings of my ice cream tubs. Please recreate the tubs on a plain white background and stick to the same Pantone colours. Here's what I'm looking for: • Emphasis ...already been created, but I need it to be convincingly brought to life in a 3D environment. Ideal Skills and Experience: • Proven experience in 3D product rendering • Expertise in highlighting packaging design elements • Attention to detail for a realistic rendering • Ability to work with existing designs and stick to them closely • Knowledge of texture mapping and lighting for a realistic outlook If you can faithfully reproduce my design in 3D and make it appealing and realistic, you...
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
...automated workflows as an intitial test: Flow 1: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and r...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm seeking an expert to improve and maximize my Office 365 email deliverability rates by boosting DMARC, SPF, and DKIM authentication protocols. I'm not completely certain if I'm experiencing any deliverability issues or ...completely certain if I'm experiencing any deliverability issues or receiving bounce-back messages, hence, expertise in diagnostic skills for these issues is highly desirable. Ideal candidate for the job should: - Have in-depth knowledge and experience with DMARC, SPF, DKIM authentication protocols. - Be capable of identifying and fixing potential deliverability problems. - Have experience with Gmail, Outlook, and Yahoo Mail services to ensure emails are properly received in those platforms. Time efficiency and meticulousness are key attri...
...Management:** As an Outlook user, you'll be responsible for keeping my inbox organized, flagging important emails, and responding to emails based on pre-set criteria. - **Calendar Scheduling:** I need someone who can effectively manage my calendar. You'll be responsible for setting up meetings, appointments, and ensuring that my schedule is well-organized and up-to-date. - **Prioritizing Tasks/Events:** I'm looking for someone who can help me prioritize my tasks and events. You need to be able to understand my schedule and commitments and help ensure I'm allocating my time effectively. The ideal candidate for this role should have: - Prior experience in personal assistance or administrative support - Excellent organizational and time management skills - Profi...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
As an IT professional, I'm looking for an expert in Microsoft's Exchange Server 2019, as I need it set up for several organizations. The server setup must allow client access through Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP). Ideal Skills and Experience: - Proficiency in Microsoft Exchange Server 2019 - Previous experience setting up servers for multiple organizations - Familiarity with various client access setups including Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP) This task involves complex server configuration so only those with corresponding expertise should apply. This job would entail making sure that setup and client access is seamless for each organization.
...that includes: - Drag-and-drop HTML editor - User-friendly interface - Ability to export emails to any sending platform - Customizable templates, Pre-designed blocks, and image hosting capabilities Necessary Skills: - Advanced comprehension of HTML and AI - Experience with software development and UI design - Proficiency in various email platforms (Mailchimp, Constant Contact, gmail, hubspot, outlook) The final product should seamlessly integrate with the aforementioned email sending platforms. Moreover, the email builder should allow for logo integration, custom color schemes, and font customization. Your commitment to creating a polished, efficient, and user-friendly product will be essential to this project. The goal is to produce a streamline HTML email building experienc...
I'm in need of a skilled animator to transform my company's vector format logo into a visually appealing 3D animation for our website. With your skillset, I aim to showcase a morphing style animation that capt...morphing style animation that captivates any viewer within a short span of 5 to 7 seconds. Additionally, I require an attractive email signature featuring the newly animated logo. The project demands creativity, mastery in animation software and an exceptional eye for modern designs. Relevant experience in 3D animation is a must, along with proficiency in creating professional email signatures for Outlook. Sharing a scale of our previous work will be part of the project's asset bundle. Prepare to invent a modern, impressive digital masterpiece that will repres...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
We required to develop some requirements to be done on Excel macro using office 365.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
We are looking for a developer to help us develop an add-in for outlook that works for outlook on windows desktop app and web app. The add-on will be able to: - Read and analyze every email and send the files to our servers - Receive inputs from our server and suggest actions (save files to specific locations, proposed responses etc)
Cerco uno sviluppatore per creare un'applicazione di pianificazione di riunioni efficace ed efficiente. L'applicazione deve essere in lingua italiana e dovrebbe consentire agli utenti di inviare proposte di date e orari per riunioni, raccogliendo le risposte dei partecipanti e confermando le riunioni automaticamente. Caratteristiche richieste: - Integrazione con Google Calendar, Outlook, Apple iCal, Teams e Meet - Raccolta del nome e dell'indirizzo email degli utenti al momento dell'invio di una proposta di data e ora per una riunione L'ideale sarebbe uno sviluppatore con esperienza in: - Sviluppo di applicazioni in italiano - Integrazione con piattaforme di calendario - Creazione di interfacce utente intuitive L'obiettivo è semplificare il...
I require a professional who has a keen eye for modern and sleek branding to create several items for my online TV channel. The various branding content needed includes: - Logo design - Thumbnail templates - An striking intro animation - Social media post content templates - Engaging outro animations - Clean and modern lower thirds...Social media post content templates - Engaging outro animations - Clean and modern lower thirds The branding needs to cater to an audience aged between 36-60 years. I'm seeking a freelancer with a modern aesthetic and previous experience with television or digital media branding. Proficiency in motion graphics for the intro and outro animations is also a must. This project calls for an innovative outlook and an ability to design with a mature au...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...
I'm seeking a professional to craft a customized email signature for my existing business. This signature will be uploaded to multiple platforms - Outlook on both Android and Desktop, iPad Mail, Mac Mail, and a generic webmail client. Key Requirements: - The email signature must include my name and job title, our company logo and tagline, as well as contact information (phone number, email address, physical address). - I need the signature to work seamlessly across all platforms, without any design or functionality issues. - It should be easily editable for quick updates when needed. - If possible, an animated version of the signature is preferable, though not absolutely necessary. Ideal Skills and Experience: - Proficiency in HTML and CSS to design and code the signature. -...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to a...columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of T...
Hi, I need to Connect each user to their microsoft outlook account. The goal is to be able to create tasks on Perfex and also show them on their Outlook calendar. For each user (about 10 at the moment) they will need to be able to link their account in my current Perfex CRM installation. In the CRM the user need to set up his account through a step by step procedure. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I'm looking for a developer who can create a module where I can plug & play to my Perfex Installation.
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...
I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable web app...
Hi, We are looking for a freelancer to send individual emails from an Outlook account to the email list we provide. Email account, emails & names list & the content will be provided. Just need to copy paste & send them (no bulk emails only individual emails). Approximately 5000 emails to be sent. Please quote with you fees for 1000 emails. We will go with a lower bid as it is a very basic task.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
I'm seeking a qualified programmer who can craft a script to simplify my email interaction by creating an automated response system. Key Features Needed: 1. The script should be configured specifically for Outlook 2. The script must send a predetermined reply to emails that contain the word 'YES' in their body. Ideal Skills & Experience: • Experience in scripting for email automation • Familiarity with the Outlook email system • Strong attention to detail to ensure correct triggers for the automated response. This project requires precision and a thorough understanding of the requested tasks. If you're able to combine your scripting prowess with detailed implementation, I'd love to hear from you.
...quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Excel sheet. Very Important: Excel Formula/Script/Code/Macro/VBA Function or whatever you can call which is embedded in and compatible with excel. (You have to open the attachment to run a script on it). When the available quantity of a spare part reaches a certain value ( Minimum Stock Value or Less ), An automatic Notification Message including the data of I.N , S.P.D , and A.Q, Will be instantly sent into my what's app Numbe...
I'm seeking a skilled 2D traditional animator well-versed in creating vibrant, bold, cartoon-style adventure animations. This project involves developing an engaging imagery that balances fun and excitement sure to appeal to a wide audience. - Ani...should solely lie in cartoon-style animation. The ability to craft engaging cartoon characters embedded in adventure-themed scenarios will be beneficial. - Theme: Primary theme of the animation revolves around adventure—implying elements of surprise, fun, and thrill should be incorporated into your artwork. An ideal candidate will possess a keen eye for cartoon aesthetics, an adventurous creative outlook, and a knack for working with vibrant color palettes. Previous experience in adventure-themed animation projects will ...
I am in need of an Administrative Assistant who is fluent in German for email management and correspondence tasks. The ideal candidate should possess the following skills and experience: - Fluent in German - Proficient in email platforms such as Wordpress, Jira, Outlook, and Hupspot - Excellent communication skills - Strong organizational skills - Ability to manage and prioritize tasks efficiently The Administrative Assistant will be responsible for managing and responding to emails on a daily basis, as well as scheduling appointments and organizing files as needed. The candidate should be able to work independently and possess a high level of attention to detail.
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentia...
I have a daily dataset of the prices and funding fees of cryptocurren...format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.
I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first closes...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowled...
...linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...
...I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • G...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
