Completed

Automate letter generation (Excel data to Word Letter)

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.

Skills: Excel, Microsoft Office, Visual Basic, Visual Basic for Apps, Word

See more: excel data word transfer, excel data word document barcode, integrate excel data word, importing data from excel to word template, mail merge in excel without word, auto populate word document from excel, excel form letter template, how to write a letter in excel 2010, generate word document from excel data, how to merge excel data into word letter, auto generated letter excel, data entry, software architecture, excel, visual basic, visual basic for apps, microsoft excel, automatically format excel data word template, copy excel data word, excel generate word letter

About the Employer:
( 1 review ) Sri Hartamas, Malaysia

Project ID: #17408527

Awarded to:

MimiFL

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 dat More

$35 USD in 0 days
(414 Reviews)
6.8

31 freelancers are bidding on average $110 for this job

schoudhary1553

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 Bas More

$200 USD in 3 days
(275 Reviews)
7.5
paris2785

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 More

$80 USD in 1 day
(164 Reviews)
6.8
osmemon

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 Experi More

$100 USD in 3 days
(34 Reviews)
5.6
vbexcel

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 E More

$55 USD in 3 days
(35 Reviews)
5.6
abhinovpankaj

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# More

$100 USD in 3 days
(62 Reviews)
5.6
LidijaP

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 More

$35 USD in 3 days
(15 Reviews)
4.8
ScareCrow01

I can do this. Not that hard. Relevant Skills and Experience Excel Proposed Milestones $101 USD - Full

$101 USD in 3 days
(18 Reviews)
4.3
lillysoft

i am expert in this kind of system development please discuss on chat

$100 USD in 1 day
(13 Reviews)
4.7
qasimalikgmail

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 in 3 days
(12 Reviews)
4.1
TetyanaS

I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET” Relevant Skills and Experience You can see my profile. Pr More

$100 USD in 3 days
(8 Reviews)
3.6
paulodayto08

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 a More

$150 USD in 1 day
(8 Reviews)
2.9
$250 USD in 3 days
(4 Reviews)
2.5
khaiminhp

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 More

$30 USD in 1 day
(4 Reviews)
1.9
alxalexfs

Hello, attach the sample files to advance a solution.

$35 USD in 4 days
(1 Review)
1.7
Mrazadata

Hi, I can help you with this. In the letter you can add a pivot table and then get the pivot table to loop through each parent company showing the subsidiary. Also, you can print straight to a doc file and save it in a More

$111 USD in 3 days
(3 Reviews)
0.9
hunugy

experienced in excel2word scripting

$133 USD in 3 days
(0 Reviews)
0.0
JICastroC

I can create a function which will concatenate the subsidiaries for you, even if you want to add multiple items products. Also I can clean the code to make it easier to anyone who use the program. Relevant Skills and More

$55 USD in 1 day
(0 Reviews)
0.0
khaliqahmad766

Hi i am

$155 USD in 3 days
(0 Reviews)
0.0
bharathbest81

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 co More

$111 USD in 1 day
(0 Reviews)
0.0
eruditeits

Hi, I already developed similar excel macro, Here is my work sample, please watch demo video Documents from Excel data [login to view URL] Relevant Skills and Experience Hi, I already dev More

$88 USD in 1 day
(0 Reviews)
0.0