Find Jobs
Hire Freelancers

Automate letter generation (Excel data to Word Letter)

$30-250 USD

Slutfört
Publicerad över fem år sedan

$30-250 USD

Betalning vid leverans
The objective is to generate letters (Microsoft Word) to customers using excel data (e.g. products, prices). I already have a pretty decent macro (adapted from online) for this purpose with one row of excel data used to populate and generate one letter. In theory, I just need to do a minor tweak the VBA code (not too long/complex) to allow for that but am unsure how to do it (see further context below). This is quite urgent so I would favor those who can complete this quickly (in a few days) Question: How do I tweak the VBA code to allow the possibility of combining more than 1 row of excel data to populate and generate just one letter? Background: Currently in excel, 1 row of data is for 1 unique legal entity/subsidiary along with the products purchased and prices. Each legal entity/subsidiary belongs to a group/parent company. There are two scenarios here: -> Each group has only 1 subsidiary (i.e. 1 row of excel data) - DONE. Macro does this -> Each group has more than 1 subsidiary (i.e. multiple rows of excel data) - HOW TO DO THIS? (i.e. to combine multiple subsidiaries/excel rows into one letter addressed to the group/parent company) Potential solution? Not sure how to do this but perhaps I need to use some "conditional if statement" to say that if the Group is not unique/repeated (more than legal entity/subsidiary), then to copy each row of information (corresponding to the no. of legal entities/subsidiaries of the same Group) and put into the 1 letter only (so an additional table with product & prices for each subsidiary) could be appended below.
Project ID: 17408527

Om projektet

29 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Modifying existing code for transferring data from excel (single or multiple rows) to a word document. Relevant Skills and Experience I've completed hundreds of projects where i generated word documents from excel data and i've never had a single problem. Proposed Milestones $35 USD - For complete work as described If you are interested in working with me, please share the sample excel/word documents so i can see what exactly you currently have and what needs to be done. Thanks, Milan
$35 USD Om 0 dag
5,0 (534 omdömen)
7,1
7,1
29 frilansar lägger i genomsnitt anbud på $110 USD för detta uppdrag
Använd avatar
Hello Sir, I have reviewed your job details and I am sure i can deliver you the job with you satisfaction. Relevant Skills and Experience I have more than 5 year of experience in Excel, Microsoft Office, Visual Basic, Visual Basic for Apps, Word . Please ping me for more discussion. Proposed Milestones $200 USD - Automate letter generation (Excel data to Word Letter)
$200 USD Om 3 dagar
4,9 (338 omdömen)
8,0
8,0
Använd avatar
Hi! I can modify your VBA code to combine multiple rows of data. I need to see your Excel spreadsheet to shape a better idea, though. Relevant Skills and Experience I'm an Excel expert. Having completed more than 230 projects during the last 5 years successfully I feel really confident in assisting with yours as well. Proposed Milestones $80 USD - Once you're happy with the modified code I can finish your project within 1 day. I'd like to talk further about this project with you whenever you're available. Please, let me know when it's a suitable time to communicate. I'm looking forward to hearing from you soon. Paris Pallas
$80 USD Om 1 dag
4,9 (255 omdömen)
7,5
7,5
Använd avatar
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones $100 USD - VBA
$100 USD Om 3 dagar
4,9 (62 omdömen)
5,6
5,6
Använd avatar
The easiest method would be append subsidiary documents to the first consolidated document. For an example of a similar app that I coded, see my Portfolio, click <see More> 4th row left most item Relevant Skills and Experience VBA coder pro, over twenty years experience in integrating Microsoft Office suites. Proposed Milestones $25 USD - Deliver code for your testing $30 USD - On your acceptance
$55 USD Om 3 dagar
4,9 (35 omdömen)
5,6
5,6
Använd avatar
I have more than 10 years of experience in Excel and VBA macros with 100% client satisfaction history. I can update your macro for multiple lines. I ll also give u free post project revision Relevant Skills and Experience Excel and VBA Macros with more than 10 years. See my profile for client reviews. Proposed Milestones $100 USD - for project Looking for your response.
$100 USD Om 3 dagar
4,8 (34 omdömen)
5,6
5,6
Använd avatar
My name is Lydia, I'm working on the computer last 15 years. My Top Skills Excel, Microsoft Office,Internet Research. Relevant Skills and Experience My Top Skills Excel, Microsoft Office,Internet Research. Proposed Milestones $35 USD - Fast and perfect
$35 USD Om 3 dagar
5,0 (15 omdömen)
5,0
5,0
Använd avatar
i am expert in this kind of system development please discuss on chat
$100 USD Om 1 dag
4,8 (13 omdömen)
4,7
4,7
Använd avatar
Basically anything can do with Macro VBA so It's feasible to do. It's probably need to create some variables and loops to add/ combine multiple subsidiaries into one. Can i help you with this? Try me Relevant Skills and Experience I've been doing excel enhancement using vba macro for over 7 years now. and I am a subject expert matter, a certified and has a strong knowledge with MS excel. Let's collaborate Proposed Milestones $150 USD - Work Completion
$150 USD Om 1 dag
4,9 (37 omdömen)
4,5
4,5
Använd avatar
I can do this. Not that hard. Relevant Skills and Experience Excel Proposed Milestones $101 USD - Full
$101 USD Om 3 dagar
5,0 (20 omdömen)
4,5
4,5
Använd avatar
Dear client, I am an expert in vba. I can modify the existing code to incorporate the suggested changes. Looking Forward Stay tuned, I'm still working on this proposal.
$100 USD Om 3 dagar
5,0 (14 omdömen)
4,3
4,3
Använd avatar
I think you should give me your both Excel & Word template over a chat box, so I could completely understand how your data organized. I will have a try if I could resolve this issue, then I will join bidding. Thank you!
$30 USD Om 1 dag
5,0 (4 omdömen)
1,9
1,9
Använd avatar
Hello, attach the sample files to advance a solution.
$35 USD Om 4 dagar
5,0 (1 omdöme)
1,7
1,7
Använd avatar
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, interesting office automation ! Do You want to definitively resolve Your goal ? I write A.I. driven full parametric software even for this purpose. Your need has this right solution, fast, clear and affordable. Feel free to contact me for any question or clarification that helps Your goal Cheers Gianni
$149 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, Mail merge function in word should resolve your issue. It will be easier than VBA. I will be able to deliver the work within 1 day of awarding the work. Thanks for reading my proposal. Regards, Shrikant
$250 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I would look forward to help you
$133 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
We will provide you exact solution u expected Relevant Skills and Experience Word, excel, vb
$166 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi there! I can complete your work.
$111 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I m good at automating in excel and word.. I could help you in writing VBA script or any addition software which will Parse the date from excel and frame the Ms word letter pad based on some condition.. Either way I could help you.. Waiting for your reply... Thanks...
$111 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
experienced in excel2word scripting
$133 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för MALAYSIA
Sri Hartamas, Malaysia
5,0
1
Verifierad betalningsmetod
Medlem sedan juli 21, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.