ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   merge two excel files like in word mail merge (https://www.excelbanter.com/excel-discussion-misc-queries/247744-merge-two-excel-files-like-word-mail-merge.html)

azmerritt

merge two excel files like in word mail merge
 
can you merge a list of names that is in an excel spreadsheet (client
listing) into a "document" that is also done in excel? I'm trying to do
"mail merge" in excel similiar to "mail merge" in word. I would like to
set-up the "document" like a template in word.

TabooCheddar

You can use visual basic in Excel to do this. This video walks through it:

https://www.youtube.com/watch?v=xHwiulx2MQc


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com