Good day VBS Guru’s!
I have an XL workbook and Word document that I use to keep
track of ~8,000 customers and their conference call accounts which has a 2nd
sheet with a list of ~3,000 e-mail addresses of problem customers/accounts. My XL workbook and Word document work together perfectly, but I need VBS help to use the two documents together to e-mail account information to each of the 3,000 e-mail addresses.
The workbook has multiple VLOOKUP commands that populate based on an e-mail
address in Cell B2. The Word document
has 25 links to the XL workbook so I just hit CTRL+A to select all, and then
hit F9 to update the links in the Word document. This works perfectly and I don’t need any
help here. Then I send the Word document
to the customer with the information.
My problem – around 3,000 of these customers need to have a
change made to their account and I cannot easily reach out to 3,000+ customers. I need a VB script that will take a single
e-mail address from the list of 3,000 customers, put it into the workbook in
cell B2, then go to the Word document, emulate the CTRL+A and F9 keystrokes and
then use Mail Merge (or whatever) to send a copy of this Word document to the e-mail, then increment to the next of the 3,000
e-mail addresses one at a time until all 3,000 documents have been e-mailed out
to the customers.
Is it possible to work with both XL and Word to do this via a VB Script? If so I can send you a sanitized list of customer information and the Word document. I am unable to upload the files...possbily because of a security policy?
Thank you in advance for your time,
Troy