Using Mail Merge in Word VBA | Pt. 1

Mail Merge is a dynamic tool that allows you to take a structured data source and use that information to create all sorts of documents ranging from letters to envelopes. Because Mail Merge is such a valuable tool to so many people, we are going to explore this feature inside of Word VBA, and how we can automate the process even further. Additionally, we will explore how to take data from Excel and use it as a source of data to use in Mail Merge.
Video Resources:
--------------------------------------------------
github.com/areed1192/sigma_co...
Resources:
--------------------------------------------------
Facebook Page: / codingsigma
Facebook Group: / sigmacoding
GitHub Sigma Coding: github.com/areed1192/sigma_co...
Support Sigma Coding:
--------------------------------------------------
Patreon: / sigmacoding
Amazon Associates: amzn.to/3bsTI5P **
Related Topics:
--------------------------------------------------
Title: How To Place Objects In Word Using VBA
Link: • How To Place Objects I...
Title: How To Work With Paragraphs In Word VBA
Link: • How To Work With Parag...
Title: How to Work With Documents in Word VBA
Link: • How to Work With Docum...
Title: Working With Templates in Word VBA
Link: • Working With Templates...
Title: Working With Building Blocks in Word VBA
Link: • Working With Building ...
Title: How to use the Find Object in Word VBA
Link: • How to use the Find Ob...
**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
Tags:
--------------------------------------------------
#Word #VBA #MailMerge

[@aceventura2154]

Very clear... Hopefully I can follow these videos tomorrow to do a little project at work.

[@ricardosierraramirez718]

Excelente, gracias por el video!!

[@ricardosierra9281]

Excelente video, gracias. Saludos desde Colombia

[@kolavithonduraski5031]

ThanksTober!

[@marvinportuguez1316]

Hello, I have tried to do the mail merge that you explain in this video, however connecting to a iSeries data base. Could you let me know how to do it? Not sure, how to create "xlDataSourceConnectionString" and "wrdMailMerge.OpenDataSource".

[@MrTrevorEnnis]

Ok, So I attempted to recreate this tutorial, but when I ran the macro, it hung on the DataSourceFile. It populated the path upto the folder that the .xlsx file was in, but didn't add the filename itself, and added .xls at the end of the resident folder in the Data Source field.
Any reason why this would happen? And the workaround?

[@castielhamza272]

i realize I am quite randomly asking but do anyone know a good place to watch newly released tv shows online?

[@vihaantucker2850]

@Castiel Hamza I dunno lately I have been using flixportal. You can find it thru google:P -vihaan

[@castielhamza272]

@Vihaan Tucker thanks, I signed up and it seems like a nice service :) I appreciate it !

[@vihaantucker2850]

@Castiel Hamza You are welcome :D

[@markrandall2207]

I seem to have an issue with "Dim wrdMailMerg As MailMerge" I get alarm Compile Error A module is not a valid type. Any ideas ?

[@ruthescobedo6590]

I've been having the same problem, were you able to make it work?