Find Jobs
Hire Freelancers

Complex mail merge format

€2-6 EUR / hour

Closed
Posted about 1 year ago

€2-6 EUR / hour

I have a complex google sheet holding orders for my home delivery service. I have about 25 products represented as columns that I fill with a # representing the amount ordered. I want to creat a mailmerge that prints a tag with he customer info, but also how many of each product ordered. What is required is a complex mail merge row filtering formula using conditional formatting (I think). The challenge is, there's usually 50 customers with 25 product options, its hard to export the mail merge while leaving the empty product fields blank, as they change for each customer. The label is for us to paste on the bag for order packing in our cooler. Sample spreadsheet attached
Project ID: 36557708

About the project

23 proposals
Remote project
Active 11 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average €5 EUR/hour for this job
User Avatar
Hi there. I can create mail merge on your sheet using the formulations or if required the appscript or macro. Lets discuss your requirement in detail THanks Vishal
€6 EUR in 40 days
5.0 (82 reviews)
5.0
5.0
User Avatar
Hello ! Good afternoon After reading your job posting, I am convinced that I am the best person to help you. I have skills in Data Entry, Data Processing, Visual Basic and Excel. I have worked in many projects similar to yours, making this an interesting task for me. Please message me for more information on how I will complete this project. Thank You Carol M.
€7 EUR in 33 days
5.0 (1 review)
4.1
4.1
User Avatar
IMPORTANT NOTICE: I understand that you are looking for someone who can create a complex mail merge format that requires a row filtering formula using conditional formatting. I believe I am the perfect fit for this project because of my extensive experience in creating desktop applications, specifically Excel desktop applications. My expertise includes designing application layouts using XAML, as well as developing them using C#/ .NET Core, APIs and other related technologies. This knowledge is invaluable when it comes to creating the mail merge format required for your project: I understand that there may be some issues with leaving certain fields blank when exporting the mail merge due to the changing contents for each customer. However, with my extensive experience in software development I am confident that I can craft a complex mail merge row filtering formula using conditional formatting that can effectively filter out all the required information while leaving the empty product fields blank at the same time.
€5 EUR in 40 days
5.0 (1 review)
1.4
1.4
User Avatar
Dear Client, Thank you for reading my response to your project. I am a skilled data entry specialist with 4 years of experience in accurately and efficiently inputting and managing data in various digital systems. I am having experience working with a range of software applications, databases, and spreadsheets, and can organize and maintain data methodically and efficiently. I am confident to easily do this task for you. Looking forward for your reply. Sincerely, Ramsha Basharat
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am looking for a freelancer who can assist me with a copy paste project. The content that needs to be copied and pasted is text only. However, I require the freelancer to use custom formatting for the copied text. The desired output format for the custom formatting is a plain text file. Ideal skills and experience: - Proficient in copy paste tasks - Familiarity with custom formatting in Microsoft Word or Google Docs - Attention to detail to ensure accuracy of copied text and formatting - Ability to deliver work in a timely manner - Good communication skills to keep me updated on progress and to clarify any questions or concerns.
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir! I will give you the work of data entry l am expert in data entry I will give you data entry work like a professional I have 2 years experience Ill give you a quick data entry job and i work in the office thank you
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very Hardworking Person And i give my best to make this project Perfect Or i complete the project as soon as possible
€8 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8 years of experience in data analysis using tools like MS Excel, PowerBi, and DevOps tools like Linux, Shell Scripting, GIT, Maven, Sonarqube, Tomcat, Ansible, Docker, Kubernetes, PLeaes give me chance to work with the project mentioned , I hope I will resolve your issues quickly
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is RAFAQAT AZEEM I am Here to Enter customer and account data from source documents within time limits, Compiling, verifying accuracy and sorting information to prepare source data for computer entry, Reviewing data for deficiencies or errors, correcting any incompatibilities and checking output, I'll Research and obtain further information for incomplete documents, and Generate reports, store completed work, I have Excellent knowledge of correct spelling, grammar and punctuation your satisfaction is my first priority.
€3 EUR in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a university undergraduate. I understand you need a freelancer to assist you to retyping history files that are in PDF format. I can do this with 100% accuracy. I also have excellent typing speed. If you select me for doing this project, I can give you the best commitment. I did my first project 100% accurately. Feel free to contact me.
€2 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, Thanks for posting the job. By going through your job description I came to know you are looking for a data entry expert You will be glad to know that I am a professional data entry with over 2 years of experience in the local market. I have a gone through your description and I believe I am capable to work on this project. In you have any question I am here to chat in the message. Thanks Musa Alam
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
focusing on the strength of your personality, your enthusiasm for the role, and what has attracted you to their company. I am an enthusiastic, professional, loyal and hard-working person who has been working towards.
€10 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii. I am offering my services in short notice. Relevant skills and experience please consider me and give me a chance to impress you by my quality service experience. Thanks
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. Greetings of the day!! I have gone through your requirement and understood every aspect of them. With my 5+ years of experience in data processing, data entry, and Excel, I believe I can help you create a formula that will accurately filter rows based on conditional formatting and print tags with customer information and the number of products ordered. I have extensive experience in working with Google Sheets and Excel and have created similar mail merge formulas in the past. I understand that the challenge lies in exporting the mail merge while leaving the empty product fields blank, as they change for each customer. However, with my experience in data processing, I can create a formula that will accurately filter rows and print tags with the required customer information and product details. I am confident that I can deliver high-quality work that meets your expectations. I am available to discuss the project in more detail and answer any questions you may have. As referring to my experience, I can fulfill all your requirements. I look forward to the opportunity to contribute my skills to your project. I will offer you seamless work with optimum quality. When you want this project to be completed? I can start this project today itself. Let's talk and get it done. Thanks and regards, Vishal G;
€6 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am currently working in a US Based Company and work as a operations Executive . I have an 2 year experience in resolving US Partner's concern using Zendesk Software (emails) and chats.
€10 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I’m an expert in excel skills. I can complete the work in minimum amount if time and for a very reasonable sum of money.
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can easily adapt to different working environments. I have worked both to public (government) and private companies and that makes me a flexible employee.
€5 EUR in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It can be hard to stand out from the crowd,but i think I'm quite good in learning new things and I'm faster.
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can do mail merge easily and potentially .Have learnt mail merging and doing this quite often ,And have a good experience in it.
€4 EUR in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AZERBAIJAN
Central, Azerbaijan
0.0
0
Member since May 10, 2023

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.