Outlook vba extract jobs
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID
...process and normalize information from building standards, the Building Code, product specifications, architectural designs, and consultant reports. - Users should be able to input or upload data via both a web and desktop interface. - Data input methods should include manual input forms, file uploads, and API integration. - Tailored ChatGPT API prompts will be used to analyze, summarize, and extract key details for each report section. - AI-generated content should be automatically inserted into a pre-formatted Word template using python-docx. - The final report should be convertible into a PDF using FPDF. - The solution must include secure API handling and proper credential management. - A potential web interface development using Flask should be considered to ensure user-frie...
Hello! I found this project that you did before. Did you create a converter tool? We need a tool or routine to convert MT940 to CSV. I will provide output format. Important is descr...description part is completed completely . The tool should be developed using Python. The CSV should follow a custom layout specified by us. The tool should include advanced error handling and logging for all operations. Please ensure errors trigger email notifications to us. Error notifications should be sent immediately when an error occurs. Please use the following method for email notifications: Outlook email. The expected turnaround time for the project is 1-2 weeks. The MT940 files will have consistent formatting. No user interface is needed for the tool. Input MT940 files will be provided ...
I'm currently developing an Outlook Addin using TypeScript. It's functioning fine locally, but I need an expert to refine the code to adhere to the Microsoft Office Add-in guidelines, and assist with deploying it to AWS. Key Requirements: - Extensive experience with TypeScript and Outlook Addin development. - In-depth understanding of Microsoft Office Add-in guidelines. - Proven track record with AWS deployments. - Expertise in setting up CI/CD pipelines. - Strong skills in optimizing TypeScript code for performance and readability. I'm looking for a professional who can help me ensure the Addin meets necessary standards and is ready for cloud deployment. Your role will also involve assisting me with the setup of CI/CD pipelines for seamless deployment. If yo...
...excellent customer service via chatbot Feedback: Collect customer feedback to improve the website and user experience. To automatically extract data from PB Tech NZ () and load it onto your website, you can use web scraping techniques. However, before proceeding, it's important to note that web scraping may violate the terms of service of the target website. Always check the website's file (e.g., ) and ensure you have permission to scrape their data. If scraping is allowed, here’s how you can automate the process: Step 1: Understand the Data to Extract Identify the data you want to extract from PB Tech NZ, such as: Product name Product description Price Images Specifications Reviews and ratings Stock availability
I'm seeking a Zapier expert to help automate a process involving email tracking and website verification. I receive emails with car VINs (Vehicle Identification Numbers) and need to check their status on our website. Key Tasks: - Read incoming emails on Gmail to extract VINs from plain text - Navigate our custom HTML/CSS website to find the corresponding VIN page - Use Zapier to return the link to the VIN page and its availability status (available or sold) Ideal Skills: - Proficiency in Zapier - Experience with Gmail - Familiarity with navigating custom HTML/CSS websites - Strong problem-solving skills This project will streamline a crucial part of my workflow, so I appreciate your expertise in making this as efficient as possible.
I'm seeking an efficient, detail-oriented freelancer for a data entry project. The task involves collecting mixed data from various online directories and inputting it into a spreadsheet. Key Responsibilities: - Navigate through designated online directories - Extract a variety of text and numerical data - Accurately input this information into a provided spreadsheet Ideal Candidates Should Have: - Previous experience with data entry, particularly from online directories - High level of attention to detail - Proficiency in using spreadsheets - Ability to work independently and manage time efficiently This project requires handling mixed data, therefore, a knack for understanding and organizing different types of information is essential. Accuracy is paramount, as the integri...
I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that ...template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro and...
... Key Tasks: - Cleanse the data from individual workbooks to a single workbook table - Transform the cleansed data into a single comprehensive table -there are approximately 300 workbooks, that each have about 8 sheets of similar data that is not tabled -extracting "amount paid to installer" sheet information is not part of this scope, but could be added at additional cost if it make since to extract that data at the same time. Do not include this in your price, but if interested chat message about details. The final table should include: - Date of sale - Customer details - Budget costs - Actual costs - Estimated costs - fields for each type of cost on the projects Ideal Skills and Experience: - Proficiency in Excel - Experience in data cleansing and transformation - ...
I need to leverage AWS Bedrock for extracting specific fields from my scanned documents. This task will involve processing a daily influx of these documents. Key Requirements: - Extract fields: Names and addresses, Dates and case numbers from legal documents. - Deploy the model across different AWS accounts. I need to learn what Bedrock models I can use for this purpose, how to train my model for better accuracy and finally, how to deploy this model to different aws accounts. Ideal Skills: - Proficiency in AWS Bedrock. - Experience in document processing and field extraction. - Knowledge in deploying models across multiple AWS accounts.
I'm looking for someone to extract data from Google and compile a list of water and fire restoration businesses in Marion County, Indiana, Hamilton County, Indiana, and Hendricks County, Indiana. The list must include - Business Name - Business Address - Phone Number It must be an up-to-date business list. The extracted data should be delivered in Google Sheets. Please ensure to cross-reference with online databases for verifying the accuracy of the business information. Ideal skills and experience for this job include: - Proficiency in data extraction and Google search - Experience with Google Sheets - Ability to cross-reference data with online databases - Attention to detail to ensure the list is accurate and up-to-date.
I need someone to transfer information from 7 Fire Risk Assessments, currently in PDF format, into a new Google Docs document using a specific template I will provide. You will need to read through and extract the correct information from the first document to populate the new template.
...Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition Logic: The flow should check if a specific field in the ag...
...Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition Logic: The flow should check if a specific field in the ag...
I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe
I'm looking for a reliable professional who can efficiently pull applicant information from various State Workforce Agency websites and transfer it to a SharePoint site daily. Key Responsibilities: - Monitor and extract data from Pennsylvania, Indiana, Kansas, and Iowa State Workforce Agency websites. - Collect specific data points including applicant names, contact information, and the date the application was submitted. - Report issues for logging into sites to project manager. Ideal Skills and Experience: - Proficiency in data extraction and web scraping. - Familiarity with State Workforce Agency websites. - Experience with SharePoint. - Strong attention to detail and ability to work consistently on a daily basis. This project requires a dedicated individual who can help...
...online and desktop versions) -- we would love your help curating a few font choices that we can select between. We serve professional and corporate clients, so we'd want this to be easy to read, yet still crisp and not overly stuffy nor too informal 2. 10 theme colors (with gradients) -- I can share our website and the virtual background that we use for video calls. I imagine you might be able to extract a color palate from this. 3. Font styles (e.g. title, heading 1, heading 2, etc.) -- I imagine this will flow naturally from #1 and #2 above, but let me know if you think differently WORK CADENCE * Ideally you could create a few alternatives for us to choose from initially * This would result in maybe 2-3 revisions (at most)? FOR THOSE INTERESTED IN PROJECT * Can you ple...
...recommendations to support workplace well-being. 2. Key Features 2.1. Predictive Diagnosis Data Collection: Manual input: Work absence history (dates, duration, reason). Self-reported workload levels and stress indicators. Integration with external sources: Wearables (smartwatches, fitness bands) to collect heart rate variability, sleep patterns, and daily activity. Email communication analysis (Gmail, Outlook) to assess volume, response time, and tone using AI-based sentiment analysis. Integration with HR management platforms (e.g., Workday, BambooHR) to fetch work schedules and performance reviews. Predictive Analysis: Machine learning models to identify correlations between absenteeism, workload, and employee well-being. Classification of work absences into "legitimate,&...
...day of each calendar year Correctly calculated annual interest Available credit line at the end of each year Technical Requirements: The spreadsheet must use formulas and/or VBA automation to ensure accurate and dynamic calculations. Must be fully functional on both Windows and Mac versions of Microsoft Excel without compatibility issues. Data should be structured for easy input and updates. The layout should be clear and user-friendly. The solution must handle different loan durations, interest rates, and varying payment schedules. Ideal Candidate: Expertise in Microsoft Excel, including formulas, pivot tables, and VBA (if needed). Strong understanding of financial calculations, especially loan interest computations. Experience ensuring cross-platform compatibility betwee...
Need to extract all emails from magento mysql database file I have the file
Need to analysis current select columns using ChatGPT API
I need help with Outlook on my Mac. I have 15 emails and I'm having trouble with the following: - Managing my To Do/Task List and booking - Syncing my Google Calendar and Exchange Server with Outlook - Events not showing in Outlook I would appreciate if a freelancer with extensive experience with Outlook for Mac could help me navigate these issues. This is an urgent project, and I would appreciate quick assistance. The freelancer must complete the project within 24 hours. The freelancer does not need to assist with organizing or migrating my emails. Troubleshooting will be conducted through a remote session. The freelancer should have an intermediate level of expertise in Outlook for Mac. The troubleshooting session should be scheduled for the mor...
I'm seeking a seasoned Python developer with a strong background in economic modeling. The project primarily involves: - Utilizing Python to build economic models based on public economic reports. - Implementing and refining algorithms to improve model accuracy and reliability. - Conducting comprehensive analyses of the data to extract meaningful insights. Ideal candidates should have: - Proven experience in Python programming, particularly in relation to economic modeling. - Strong data analysis skills. - Familiarity with public economic reports and their application in modeling. - Excellent problem-solving skills and attention to detail. Please provide examples of similar work you've completed in your proposal.
I'm looking for a skilled Python developer who can create a bot testing script for a test-taking application. This script should integrate OCR (Optical Character Recognition) technology to enhance its functionality. Key Responsibilities: - The bot will need to extract text from images, specifically screenshots of digital content within the application interfaces. - The ideal candidate will have experience with OCR technology and Python, as well as a solid understanding of bot development and integration. Skills and Experience: - Proficient in Python - Experience with OCR technology - Familiarity with bot development - Understanding of digital content processing - Able to work with application interfaces Please provide examples of similar projects you have worked on in your ...
I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, please write "DATA" in your message.
...The insights will be used to craft a high-quality, engaging article that we aim to publish in Entrepreneur Times Magazine. Responsibilities: Schedule and conduct professional video interviews with C-suite executives. Prepare insightful and engaging questions tailored to the interviewee’s expertise. Record, edit (if necessary), and submit the video interview recording along with the article. Extract key takeaways and compile a compelling article from the interviews. Ensure a professional and high-quality video interview experience. Requirements: Experience in journalism, content writing, or business interviews. Strong communication and interviewing skills. Ability to summarize and present insights in a clear, engaging manner. Professionalism and discretion in dealing wit...
...Needed for Automated HTM to CSV Converter ( Data) ? ? Project Overview: I am looking for a skilled software developer to create an automated system that converts large HTM files (100MB+) into multiple CSV files (each under 8MB). This software will be installed locally on my laptop and should efficiently process backtest results for analysis. ? Key Requirements: ✅ Automated HTM to CSV Conversion – Extract structured data (trades, timestamps, profit/loss, balance, etc.). ✅ File Splitting Logic – Ensure each CSV file remains under 8MB while preserving data integrity. ✅ Standardized CSV Format – Make sure the output files are structured for easy merging and analysis. ✅ User-Friendly Interface – Simple software UI for selecting files and running conversions. ✅ ...
I'm in need of a skilled translator who can help me with translating a cosmetic products description from English to German. The text is an extract from my website hence requires previous experience with working on such files. and is between 90 words. Key Requirements: - German Fluency: A native German speaker or a professional with a high level of German proficiency, capable of conveying the message accurately and naturally. - Translation Skills: Experience in translation, particularly in the cosmetics industry, will be highly regarded. - Attention to Detail: The translated content should maintain the original context and tone, ensuring that it is articulate and coherent. - Time Management: I'm looking for someone who can deliver the translation within a reasonable ti...
...alternative automation tool) to ensure a seamless data flow. ✅ The system must work 100% autonomously after setup, without manual intervention. ? Requirements: ? Expertise in , Zapier, n8n, or UiPath. ? Experience with API integrations for email marketing (, , SendGrid). ? Experience with VoIP (Twilio, Plivo, JustCall) for auto-dialing automation. ? Ability to extract contacts from , , Phantombuster, and LinkedIn. ? Experience in automating lead processing and AI-driven workflows. ? Workflow Expected: 1. Automate data collection → Emails & phone numbers extracted from multiple sources. 2. Auto-send emails → Contacts sent to email marketing software for automated outreach. 3. Auto-call contacts → Phone numbers transferred to VoIP for mass
I'm in need of a skilled data scraper who can extract text data from various websites and deliver it in a JSON format suitable for training a Language Learning Model (LLM). Key requirements: - Proficient in web scraping and familiar with extracting text data. - Experienced in structuring and delivering data in JSON format. - Understanding of the requirements for LLM training data. Please provide examples of previous similar projects in your bid.
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm looking for an expert in data extraction and cold outreach to help my merchant export company. Key Responsibilities: - Extract data of purchase managers from the United States, United Kingdom, and Australia. - The data should include their Name, Email address, and Phone number. - Organize the extracted data into a CSV file. Ideal Skills: - Proficiency in data extraction and analysis. - Experience in B2B cold outreach, specifically targeting purchase managers. - Familiarity with export-import industry is a plus. - Excellent attention to detail and data accuracy. Your role will be pivotal in helping me initiate email campaigns and WhatsApp bulk messages to potential business partners.
...spot,+click+on+the+following+link:%0A%0A The rpid value should be fetched from the database and made available as a tag in the message. The user should be able to share their unique link with their rpr code. Extraction and Availability of rpid and rpr Currently, rpid is not available in RafflePress settings. The plugin structure needs to be modified to extract these values from the database and make them accessible within the WhatsApp shared message configuration. Compatibility and Configuration: The action must be natively integrated into RafflePress. Administrators should be able to edit the default message and parameters in the backend. Benefits and Justification: Since 95% of potential prospects use WhatsApp, this functionality is crucial to
My small Django app running in a Docker container isn't displaying static folder , specifically CSS and JS files. This should be an easy fix, as I have confirmed that: - The correct static file directory is specified in the Django settings. - The collectstatic command has been run to gather all static file...easy fix, as I have confirmed that: - The correct static file directory is specified in the Django settings. - The collectstatic command has been run to gather all static files. - The static folder is accessible within the Docker container's file system. I need a freelancer with expertise in Django and Docker to diagnose and resolve this issue promptly. when you dowload the file you need to extract it in a folder and type: sudo snap install docker sudo docker-c...
...of AI-Powered CV Assessment Automate the screening process to evaluate candidate qualifications. Provide real-time feedback and suggestions for improvement. Match candidates with suitable job opportunities based on resume insights. Standardize the evaluation criteria to ensure fairness and accuracy. 2. Key Functionalities 2.1 Resume Parsing AI Components: Natural Language Processing (NLP) to extract structured data from unstructured text. Named Entity Recognition (NER) to identify key information (skills, experience, education). What It Does: Extracts key sections: Work experience, education, skills, certifications, projects. Identifies inconsistencies (e.g., employment gaps, missing skill descriptions). Standardizes formatting for better readability. 2.2 Skill Assessment &...
...engagement. I need a professional with experience in email deliverability and spam prevention. Your tasks will include diagnosing the issue, suggesting improvements, and implementing necessary changes to ensure my emails reach the intended inbox. Please share your relevant experience and proposed strategies to tackle this issue. The primary recipients of my emails are public domains such as Yahoo, Outlook, etc. I have currently implemented SPF, DKIM, and DMARC. The email volume is moderate, with emails being sent weekly. The emails primarily contain transactional content. The email content has been reviewed for elements that might trigger spam filters. The emails are currently being sent through a third-party service like Mailchimp. No need for assistance with email content ...
I need a proficient web scraper to extract detailed shipping data from AliExpress products. Key Information to be Scraped: - Shipping options - Shipping costs - Estimated delivery times - Shipping Country - option to add the countries i want to scrape Need to be able to scrape all shipping methods/options and cost. I should be able to add the link(s) of the products i want to scrape and output to be in file format for easy view. i should also have the option to choose the countries all or specific countries i want.
I'm in need of a skilled developer who can create a responsive email template. The template must be compatible with Gmail, Outlook and Apple Mail, and it should be built without using media queries. (just only 1 page) Key Requirements: - Expertise in responsive email template development - Proven track record of Gmail, Outlook and Apple Mail compatibility - Ability to deliver ASAP Please include in your application: - Your previous work, particularly any responsive email templates - Your experience in the field - A detailed project proposal explaining how you plan to tackle this project. I look forward to your applications.
Project Objectives: The primary goal of this project is to gain insights into customer movement and behavior within the store to measure conversion rates (leads vs. actual buyers) and better understand the target audience. Project Description: The system will integrate with the existing CCTV infrastructure (Hikvision DVR) to extract and analyze customer data, providing the following functionalities: 1. Customer Counting: o Count the number of customers entering the store, excluding employees. o Avoid duplicate counting of the same customer. o Generate reports filtering customer traffic by time of day, days of the week, etc. o Extend this functionality to outdoor cameras to compare passerby traffic with actual store visitors. 2. Demographic Identification: o Determine customers'...
I'm looking for a Python script that can download photos from specific pages on a site similar to Troostwijk Auctions. The script sh...for a Python script that can download photos from specific pages on a site similar to Troostwijk Auctions. The script should save the photos as JPEGs. Key Requirements: - The script should be able to navigate to specific pages and extract photos. - It should save the downloaded photos in JPEG format. - and download photos in a specific folder Ideal Skills: - Proficiency in Python, with particular experience in web scraping and automation. - Knowledge of handling and processing image files in Python. Please note that the specifics of which pages to extract photos from and the method of executing the script will be clarified after the ...
I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.
We are seeking an experienced Chrome Extension Developer to build a custom extension for , our lead generation platform. This extension will allow users to easily extract, enrich, and manage lead data directly from their browser—similar to tools like Apollo, Skrapp, Lusha, and others. The extension will integrate seamlessly with , enabling users to capture contact information (emails, phone numbers, LinkedIn profiles, etc.) from various websites and social media platforms, and store it in their account. Key Responsibilities: Develop a Chrome extension that allows users to extract lead data (emails, phone numbers, job titles, LinkedIn profiles, etc.) from websites and social media platforms (e.g., LinkedIn, Gmail, etc.), similar to Apollo, Skrapp, and Lusha
We are looking to hire an experienced Chrome Extension Developer to build a lead generation tool similar to Apollo, Skrapp, Lusha, or SalesQL. The extension should allow users to extract contact information from websites (such as LinkedIn, Gmail, etc.), verify email addresses, and store the data in a manageable format. Key Responsibilities: Develop a Chrome extension that integrates seamlessly with major websites to scrape user contact information (email, phone, LinkedIn profile, etc.). Implement advanced search and filtering capabilities to refine data. Ensure data privacy and compliance with relevant laws (GDPR, CCPA, etc.). Build features for users to export data to CSV, Google Sheets, etc. Implement a user-friendly interface and dashboard. Perform extensive testing and debuggi...
I'm looking for someone to send my cover letter and resume to a list of recruiters. Details: - The email addresses are in an Excel spreadsheet. - I want the emails to be personalized with each recruiter's name, but not tailored to their specialization. - I would like email to come from a gmail address Ideal skills for this project: - Proficiency in Excel - Excellent written communication s...- The email addresses are in an Excel spreadsheet. - I want the emails to be personalized with each recruiter's name, but not tailored to their specialization. - I would like email to come from a gmail address Ideal skills for this project: - Proficiency in Excel - Excellent written communication skills - Ability to personalize mass emails - Familiarity with email services such a...
I'm looking for someone to extract stock symbols (tickers) for companies listed on the NSE and BSE, and enter them into an Excel spreadsheet. I need this done just once, so there's no need for ongoing updates. Skills and experience ideal for this job include: - Proficiency in data entry and Excel - Familiarity with stock markets, particularly NSE and BSE - Ability to accurately extract and input data.
I'm looking for a professional who can convert my Outlook backup PST file into a PDF. (without attachment) . *** PLEASE NOTE , MY OUTLOOK BACKUP PST FILE IS 6 GB AND 97210 EMAILS *** I HAVE TO CONVERT IN ONE PDF FILE *** You will have to show and abstract to have the REWARD. Thank you
I'm in need of a skilled database analyst who can extract financial information from various companies. The extracted data should be delivered to me in an Excel report. Ideal Skills: - Proficient in data extraction and analysis - Experienced in working with financial data - Excellent Excel skills - Attention to detail Please note, the specific financial details to be extracted will be discussed later.
Simple and minimalistic e-mail signature with clickable links ( phone, website, tiktok, facebook, instagram) I will provide guidline ( brand book, logo, colours etc. ). I need a graphic design as well as html code - for proper display.
