'Documents are based on the Normal template MyPath = InputBox(MyText, Title, Default)ĭocName = MyPath & MyName & " " & LTrim$(Str$(Counter)) & ".doc" MyName = InputBox(MyText, Title, Default) Letters = Selection.Information(wdActiveEndSectionNumber) ' Macro created 16-08-98 by Doug Robbins to save each letter created by a Would you check my macro syntax to make sure I set it up properly? Can't think why else it is not working. However, when I run it the merged file disappears. Can you help? Thanks.ĭoug, I set up the macro (I believe) as you describe on your website. However, I cannot figure out how to split the two pages into separate files. Jeeped, I successfully converted a two page Word document to. "milt49" wrote in message news:*** Email address is removed for privacy ***. If you are using Word XP or later, the “Add-in to Merge Letters to Separate Files” on which Graham and I have collaborated and which can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field Hope this helps, Doug Robbins - MVP Office Apps & Services (Word) It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy Thanks.ĭoug Robbins - Word MVP dkrmvpsorg I'm trying to avoid having to type each document separately. Can I do this using form fields or some other way? How can I merge data from an Excel worksheet to a letter in Word so that I can then save each document separately? Mail merge in Word does not allow me to save the created documents separately. In the data source with a minimum of fuss. If you are using Word XP or later, the “Add-in to Merge Letters to Separate Files” on which Graham and I have collaborated and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field See the “Individual Merge Letters” item on fellow MVP Graham Mayor’s website at:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |