Get Data, Populate Template, Print, Get Data from following row

[cruspy]

Hi, I'm trying to put together a macro wherein it will get data from multiple cells on one worksheet, input them into different cells on my template, print, and then continue working down the list until the end. What I'm using is below. The problem is that it prints 2x copies of each print while also starting at row A61 instead of the top, A6.

Sub <gs id="461c1229-4e31-4151-90ab-1458a1c03919" ginger_software_uiphraseguid="8fefc92a-3b97-4123-91dc-8fa20a9ad7af" class="GINGER_SOFTWARE_mark"><gs id="d8b9e8ee-e223-4fb2-9187-770a834813ee" ginger_software_uiphraseguid="3c0ca7c2-03af-479a-b771-3eddb5becfc3" class="GINGER_SOFTWARE_mark">PrintLoop</gs></gs><gs id="3cbd25eb-aef7-4c19-b0af-084d1282feda" ginger_software_uiphraseguid="8fefc92a-3b97-4123-91dc-8fa20a9ad7af" class="GINGER_SOFTWARE_mark"><gs id="797a1a89-74f2-484d-a948-db0c194a6174" ginger_software_uiphraseguid="3c0ca7c2-03af-479a-b771-3eddb5becfc3" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="2cdd6194-4a63-4106-af77-39ccc1de0c52" ginger_software_uiphraseguid="8fefc92a-3b97-4123-91dc-8fa20a9ad7af" class="GINGER_SOFTWARE_mark"><gs id="60bf3d46-c9c3-421a-8435-3dd5b24d9582" ginger_software_uiphraseguid="3c0ca7c2-03af-479a-b771-3eddb5becfc3" class="GINGER_SOFTWARE_mark">)</gs></gs>Dim LR As Long, <gs id="67ed8722-2b1c-44df-a8b6-2e1f6ac7e11e" ginger_software_uiphraseguid="8fefc92a-3b97-4123-91dc-8fa20a9ad7af" class="GINGER_SOFTWARE_mark"><gs id="81b84e51-6df2-4906-89f2-ce38f0bd6a28" ginger_software_uiphraseguid="3c0ca7c2-03af-479a-b771-3eddb5becfc3" class="GINGER_SOFTWARE_mark">i</gs></gs> As Long
Application<gs id="7be7ba73-9144-415d-a6b1-094cbc610a2e" ginger_software_uiphraseguid="03d1ec70-46c8-4234-8188-c9a72c7938d6" class="GINGER_SOFTWARE_mark"><gs id="b3252804-cd1e-47fb-abfb-ca20d0a2de4f" ginger_software_uiphraseguid="486ca1c6-4355-446b-b165-c00bff7a0691" class="GINGER_SOFTWARE_mark">.</gs></gs>ScreenUpdating = False
With Sheets<gs id="05d07455-914e-4c5c-9cf0-f555118cb1f6" ginger_software_uiphraseguid="29603337-79b0-47a4-971a-f80cf4cc0ab3" class="GINGER_SOFTWARE_mark"><gs id="15f70439-fc20-419d-959d-4177cad87153" ginger_software_uiphraseguid="eb039b14-eba7-4306-8906-8b3c998446b7" class="GINGER_SOFTWARE_mark">(</gs></gs>"Test")
    LR =<gs id="b9ec1c97-2563-453d-8eb4-8c6ee0b82e0f" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="e4cf1c24-65c5-4d96-b27e-101586b3ac01" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark"> .</gs></gs>Range<gs id="a3d1554b-8e5a-4ef7-a592-66f31606dbc9" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="eb99ad2b-9b7a-465e-bc54-bc0a8e515bf4" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">(</gs></gs>"A" & Rows<gs id="31a9d452-533f-4087-b8f8-57393ff71ff4" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="2603745b-54a3-4f67-ad48-5e6a75e36098" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">.</gs></gs>Count)<gs id="15b8a758-0381-4d72-929b-ca52929d2344" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="b2367f92-8ee3-4ab9-9ca7-618afa61faa9" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">.</gs></gs>End<gs id="5bede1bb-1cf6-4c7f-b5e1-960d8c09ff81" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="b962d78a-3a98-4f1b-a755-5b06352662b5" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="45356158-5e3f-4d20-ba60-96685884d039" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="bec45bb5-3ae2-4453-992c-32712f467761" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">xlUp</gs></gs>)<gs id="8aeadf6e-101d-40a9-8d2f-fb665687b6fd" ginger_software_uiphraseguid="2ef54b6d-ef65-48a8-be13-148767b1229e" class="GINGER_SOFTWARE_mark"><gs id="f1a53473-7831-446e-988b-daf62435857d" ginger_software_uiphraseguid="6dc46e33-e2bd-435f-848e-e75c018d2c69" class="GINGER_SOFTWARE_mark">.</gs></gs>Row
    For <gs id="59de34cb-f98f-470e-8e16-a7c059383b45" ginger_software_uiphraseguid="80a7b044-98bc-432e-8663-6e0488dcb110" class="GINGER_SOFTWARE_mark"><gs id="cb6eb85b-c78e-4c9b-a507-dd2fe0e22243" ginger_software_uiphraseguid="20630e3d-b10a-4db0-9ac9-faca2aa61b7a" class="GINGER_SOFTWARE_mark">i</gs></gs> = 1 To LR
        Sheets<gs id="e52f90dc-2ad1-4cb1-b346-babf0ba7ea07" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="6a918cf3-2946-4008-9245-1503c94b2ab0" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">(</gs></gs>"Trade Deal")<gs id="e1395e18-97a3-4fae-88be-85c558816016" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="f8e11ba1-6f29-4376-9c10-a9762781a8ec" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">.</gs></gs>Range<gs id="dce76d35-0e98-40a3-b932-331da366bf09" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="100b72e6-eaee-40aa-9f99-07992a79999d" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">(</gs></gs>"G6")<gs id="02daf9a0-d370-4898-83dd-9d3fd53e5eab" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="121f30dc-a8c3-4da0-bd09-d16b10782679" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">.</gs></gs>Value =<gs id="b89cabaa-c4f0-46c4-9688-7ef3a5e32a65" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="54064ec1-8b23-47cb-ab4c-e92d7cd7340c" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark"> .</gs></gs>Range<gs id="ca06c4fb-af0a-4274-983c-cb09f7b25c42" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="b09261dd-942b-49d5-a848-e122be94571a" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">(</gs></gs>"A6" & <gs id="fc4a1866-cb12-4647-b680-d168552061a7" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="935e7043-0594-4090-b990-276d5151b894" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">i</gs></gs>)<gs id="607bf001-4943-4e97-93db-ea1eaefbb01a" ginger_software_uiphraseguid="6c103627-f9d1-49ad-a107-1eeb48dfc1af" class="GINGER_SOFTWARE_mark"><gs id="f4797963-8662-4c5e-9ace-a47fe6202376" ginger_software_uiphraseguid="42187e2c-f4be-4371-9fe9-9122c1838b2f" class="GINGER_SOFTWARE_mark">.</gs></gs>Value
        Sheets<gs id="5a588312-8f26-4f85-81ba-5ae2fc9ca021" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="c0e231a5-5dce-4dbd-9cfa-a6cb9e8b1305" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">(</gs></gs>"Trade Deal")<gs id="86f3c1c6-c810-4848-84c3-1721e6e781aa" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="93b58eaf-8a12-467d-aa05-80d256819ca1" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">.</gs></gs>Range<gs id="883fa3c1-4881-49b8-ae0f-988f2f2414c2" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="f7c038b8-5379-4378-826b-c23a049e3ead" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">(</gs></gs>"B8")<gs id="f6d48039-34ae-470d-a214-7056e45b797a" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="15800c42-3f5b-4268-a71b-f123d576db24" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">.</gs></gs>Value =<gs id="fc3d9bba-4ee4-47f1-83a5-329837a37e72" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="91aa0099-3b72-4de3-8d75-5fd578c577c6" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark"> .</gs></gs>Range<gs id="62a2821a-15bf-4a86-97e1-81aa8915e9eb" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="ea7fd875-c176-4a24-a34a-1d04e5c8795b" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">(</gs></gs>"C6" & <gs id="4f42ffb8-609f-418d-a43d-c803f6bde3c5" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="6e5307d9-4f04-42a2-88bb-ad4db6dbfdd4" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">i</gs></gs>)<gs id="ffe1c576-4fbc-4ebf-bc44-2dc742458f1a" ginger_software_uiphraseguid="c025f2e1-dc63-4fc7-9070-a529764fe074" class="GINGER_SOFTWARE_mark"><gs id="305d0623-ce5f-4a8e-b714-2c906e359960" ginger_software_uiphraseguid="e4a1a817-d5d5-4563-b754-65bbe73d092c" class="GINGER_SOFTWARE_mark">.</gs></gs>Value
        Sheets<gs id="68d4785a-4c8c-44c1-ade1-c3f15385acce" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="913e062d-330d-4a35-b6ad-74e80c6488eb" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">(</gs></gs>"Trade Deal")<gs id="0b4258a8-ab78-47f2-8d60-6e9247fee0ad" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="6e54f11f-a9a6-4693-b1ee-897a32b711e0" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">.</gs></gs>Range<gs id="9de20eb8-6cfc-4eb4-8b56-497804be6a8d" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="a98efe68-0ea3-40de-b1c8-cae309b6df7e" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">(</gs></gs>"B9")<gs id="d9b23f41-d49a-4b7b-9207-4369473ff239" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="d28eb720-a3a1-4999-b583-5e6f9adaa9f5" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">.</gs></gs>Value =<gs id="6d46033b-6dec-4e30-bbaa-0b7fa37b467a" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="02cfec05-34ae-4420-a2bc-74e1d9533c6c" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark"> .</gs></gs>Range<gs id="7467860c-2b41-4700-863a-26b650a0a29f" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="76a32734-5812-4d9d-aa54-9433da4a5bf3" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">(</gs></gs>"E6" & <gs id="de2012cf-9a7a-4f61-afcf-0b29c77a8f7f" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="6f362a57-27fa-4a32-ba5e-bee925387add" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">i</gs></gs>)<gs id="827640a4-9d15-465d-a778-6d7d9e2c5b0f" ginger_software_uiphraseguid="c600a89f-0e72-4a13-834b-794008ec32a4" class="GINGER_SOFTWARE_mark"><gs id="b9c4feb5-04c4-4d4d-9b19-a0c4fe33fd91" ginger_software_uiphraseguid="6e2e92b7-ca96-4244-9aeb-528db8b06cdd" class="GINGER_SOFTWARE_mark">.</gs></gs>Value
        Sheets<gs id="cea708c5-9bb5-4a48-ab48-8a7d54409c8a" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="0b4c9b9d-f6bf-446b-9417-2e7e13f5db50" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">(</gs></gs>"Trade Deal")<gs id="f17fe012-abf2-4510-975d-28517d88a998" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="2106c701-2350-41a3-bf7b-67717c4342a7" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">.</gs></gs>Range<gs id="6f215a1b-8813-4c76-8a99-c420e6474d6e" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="a6b7dcf3-4f1d-4191-9057-c8a3f45307da" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">(</gs></gs>"F12")<gs id="cbf7d35c-baad-4b9a-8590-2a8d624053c7" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="0067b79f-ca54-4f01-bc7e-174c1442fc9f" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">.</gs></gs>Value =<gs id="ff11f01e-a89b-4112-9aa5-f3d2e3b035c7" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="783d1349-1b63-4f2f-a5e1-80b3dd63bb92" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark"> .</gs></gs>Range<gs id="15e0490f-77ef-4ec3-af67-8b8efbb78ea6" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="d7d052fe-2528-4226-ba5f-a20062cbabba" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">(</gs></gs>"R6" & <gs id="c32ee95d-0f92-4d1c-9e04-6d96ef5c5a4f" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="f0929d16-c369-4ebf-9f54-35d77e526e09" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">i</gs></gs>)<gs id="d3a488ab-eab9-4a9d-87ab-2fbeeac4498a" ginger_software_uiphraseguid="16ba9e79-307d-40f7-88b0-2f532e4baa2b" class="GINGER_SOFTWARE_mark"><gs id="8c3dcfb0-3d74-44ca-82b4-3289e69e14b7" ginger_software_uiphraseguid="7c2ae7ba-298e-4c72-aed5-0237eb3853d3" class="GINGER_SOFTWARE_mark">.</gs></gs>Value
        Sheets<gs id="12189a47-d8a0-4da3-8f2a-c2927245eb32" ginger_software_uiphraseguid="e9ad33ae-9248-4ca5-8a83-a6c4476bc408" class="GINGER_SOFTWARE_mark"><gs id="98096319-58f9-474d-a8ee-1fd0724d5985" ginger_software_uiphraseguid="15d764b3-0aff-4752-8dce-4a470a9352a2" class="GINGER_SOFTWARE_mark">(</gs></gs>"Trade Deal")<gs id="af8380af-5c03-48ca-99a0-5e136fa42076" ginger_software_uiphraseguid="e9ad33ae-9248-4ca5-8a83-a6c4476bc408" class="GINGER_SOFTWARE_mark"><gs id="f0aed977-bebe-424d-8b12-a77c70446a41" ginger_software_uiphraseguid="15d764b3-0aff-4752-8dce-4a470a9352a2" class="GINGER_SOFTWARE_mark">.</gs></gs>PrintOut
    Next <gs id="3075eb2b-dad0-4eda-bc3d-082d43c5da36" ginger_software_uiphraseguid="f4a5e08f-1fb9-4755-9ab4-23ad9ca0d9f7" class="GINGER_SOFTWARE_mark"><gs id="87e74211-e9f8-487d-9570-62ce42af7e02" ginger_software_uiphraseguid="85194d43-0808-4cae-ba14-93326f5f1915" class="GINGER_SOFTWARE_mark">i</gs></gs>
End With
Application<gs id="4da907b3-517e-49a4-95f2-218676342b11" ginger_software_uiphraseguid="548cc5ab-548f-4831-b208-975fed4615ca" class="GINGER_SOFTWARE_mark"><gs id="a83bf0b6-0ec8-43d7-ac31-cba538e3b0f4" ginger_software_uiphraseguid="9fd7f0fd-1168-41d4-8592-d4f135f62e3d" class="GINGER_SOFTWARE_mark">.</gs></gs>ScreenUpdating = True
End Sub

Here's an image of what I'm looking to do with a bunch of <gs id="b1c5bee2-f8b3-4f69-840a-75261add90e6" ginger_software_uiphraseguid="7d135621-24f2-41de-bced-02eb7de41352" class="GINGER_SOFTWARE_mark"><gs id="034e0099-b6f9-4bd9-9329-3f67fea7e82f" ginger_software_uiphraseguid="94f3dcc8-6be8-400b-9d94-2dd150db896c" class="GINGER_SOFTWARE_mark">blacked</gs></gs> out content (sorry if it looks annoying).

Any help would be greatly appreciated, thanks!

 

[Kyle123]

Wouldn't a mail merge be much easier?

 

[cruspy]

Wouldn't a mail merge be much easier?

I'm really new with putting together macros. I usually grab stuff from the forums and edit it myself. This is the first time I've actually had a problem despite playing around with the code. What would a mail merge for my task look like? Thanks for the post!

 

[Kyle123]

It's not code, its functionality for doing exactly what you're doing built into word

https://www.ablebits.com/office-addins-blog/2014/05/08/mail-merge-excel-word/

 

[cruspy]

It's not code, its functionality for doing exactly what you're doing built into word

https://www.ablebits.com/office-addins-blog/2014/05/08/mail-merge-excel-word/

I confess but I haven't been able to follow along completely. I'd prefer code since it simplifies the steps for an old geaser like I :0). Would you happen to know where I went wrong with my code in the meanwhile? Thanks again for your input!