Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
hbj hbj is offline
external usenet poster
 
Posts: 35
Default Open a word mail-merge document from Excel VBA

I have an Excel workbook with data to a word 2007 mail-merge file. When I open the Word file with VBA an old version is opened without merging data. When I open it the normal way, I get the question to perform or not perform the SQL-statement.
How can I automate the SQL statement from VBA and perform the merge?
Håkan
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Open a word mail-merge document from Excel VBA

Why not use Excel as your Full mailmerge without using Word. Send me a mail to and I'll send you the worksheet. Very small and compact and I use it all the time.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do mail merge from excel worksheet to word document. hiron Excel Discussion (Misc queries) 1 November 13th 07 10:24 PM
Need help on mail merge excel file into word document Lynn Excel Discussion (Misc queries) 6 April 20th 07 05:30 AM
How can I do a mail merge w/ Excel contacts into a Word document? waterboy Excel Discussion (Misc queries) 1 September 27th 06 02:45 AM
How do I attach an excel document to a word one for mail merge? Ruth Excel Discussion (Misc queries) 1 January 6th 06 10:29 PM
Mail Merge Word Document From Excel VBA Pablo_In_NZ Excel Programming 0 September 8th 04 07:06 AM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"