This is great! Thanks. Just one question - If I need to email each letter separately, how do I save each letter (quickly) as a separate document/letter? Thanks!
Hi! By quickly i take it you mean without going through each individual record using current record when merging to a new document. Unfortunately there isn't. You either have to merge each record separately to a new document or all of them to a single one. Maybe i'll look into some VBA about a quick way to handle this and post about it in the future, since you are not the first one to ask about it. Thanks for dropping by!
thank you so much for this!!!! one question though. I have a form that prints 2 forms on one page. the top half and the bottom half. When I enter the fields they print the same info in both the upper and lower. I found that if I enter a field between the top and bottom that it does the next record as I'd like. But when you go to page 2 the one on the bottom now goes up to the top and the 3rd record goes on the bottom. I would like records 3 and 4 to appear. I tried to enter another at the bottom of the page but that doesn't seem to help. any ideas?
If you are still looking for a solution to this, send me the file and i can have a look. I can't tell what's going on without being able to check the actual file and see what is actually going on.
@@MichaelPSmith-mp1fk Drop me an email at footiepunter [at] gmail.com. I'm a little busy these days though, so it could take me a few days. I'll take a look and see what i can do.
After you changed the data in your excel sheet, just open the Word document again and click Finish and Merge. The new merged documents will reflect the changes made to the excel file.
Thank you very much. You really help me a lot.
Glad to hear that!
Thank you so much!
You're welcome!
Thanks, this video of yours saved me from a lot of trouble 👍🏼
You are welcome! Glad it helped!
You totally just saved me. Thank you!
You are welcome!
This video saved me a lot of time and effort. Great video!
Thank you! You save me from my exam
You are welcome! Glad i could help!
Easy to follow, thank you! :)
Glad you liked it. You are welcome!
Very helpful. Thank you.
You are welcome.
Thank you so much. This was sooooo helpful.
You are welcome! Really glad i could help.
Thank you for providing this instruction, this is very useful! :-)
You are welcome, Timo. Glad you liked it!
awesome video thank you so much ...m so hppy i found solution for my question:)
You are welcome. Glad i could help.
This is great! Thanks. Just one question - If I need to email each letter separately, how do I save each letter (quickly) as a separate document/letter? Thanks!
Hi! By quickly i take it you mean without going through each individual record using current record when merging to a new document. Unfortunately there isn't. You either have to merge each record separately to a new document or all of them to a single one.
Maybe i'll look into some VBA about a quick way to handle this and post about it in the future, since you are not the first one to ask about it. Thanks for dropping by!
Thanks you!
You are welcome.
Thank you
OHH
You are welcome!
Thanks
You are welcome!
thank you so much for this!!!! one question though. I have a form that prints 2 forms on one page. the top half and the bottom half. When I enter the fields they print the same info in both the upper and lower. I found that if I enter a field between the top and bottom that it does the next record as I'd like. But when you go to page 2 the one on the bottom now goes up to the top and the 3rd record goes on the bottom. I would like records 3 and 4 to appear. I tried to enter another at the bottom of the page but that doesn't seem to help. any ideas?
If you are still looking for a solution to this, send me the file and i can have a look. I can't tell what's going on without being able to check the actual file and see what is actually going on.
@@winoffice that would be great! Email address?
@@MichaelPSmith-mp1fk Drop me an email at footiepunter [at] gmail.com. I'm a little busy these days though, so it could take me a few days. I'll take a look and see what i can do.
Hi, again. I didn't receive anything yet. Just a heads up to let you know that in case you emailed me i didn't ignore you.
is it possible , if we changing the data in excel sheet and on run time automatically changes occur in word document ?
After you changed the data in your excel sheet, just open the Word document again and click Finish and Merge. The new merged documents will reflect the changes made to the excel file.
can we get multiple rows into many documents
Yes, you can. Just write your text and insert merge fields where needed.
WinOffice I mean if I have ten records in excel, I want to get 10 individual word file instead single word.
This is actually what happens by default. Once you click Finish and Merge you will get one document for each record.
WinOffice yah one document for each record in same file. I want to get different files for each record.
No, unfortunately that's not possible.
Thank you!
You are welcome!
You are welcome, Frank.