Thread: [Solved] Automate daily mail merge
View Single Post
 
Old 12-02-2013, 03:56 PM
macropod's Avatar
macropod macropod is online now Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi JCInfo

Depending on the URL and how the data are accessed, it may be possible to automate this with a VBScript run (or other executable) from the Windows Task Scheduler. The code would need to:
• start Internet Explorer
• access the website
• download the CSV
• quit Internet Explorer
• start Word
• open the mailmerge document
• connect to the data source
• execute the merge
• close Word
• quit

I have no idea about any Cloud-based processing and have had little involvement with I.E. automation.

IMHO, it would be best to consult a programmer for this. From what you've posted, I doubt it would be a large project.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote