Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2012, 01:57 PM
ChrisMan ChrisMan is offline Mail Merge from Access Query to Word Windows 7 32bit Mail Merge from Access Query to Word Office 2003
Novice
Mail Merge from Access Query to Word
 
Join Date: Dec 2012
Posts: 2
ChrisMan is on a distinguished road
Default Mail Merge from Access Query to Word

Sorry for another mail merge thread... but I cant seem to figure this out.



I have the module code from the MSDN site that pulls up my word template, but once open it always asks what "table" to pull the data from.





I want to use an Access Query, "OPEN SCAR" where it asks you for the record number, selects just that one record and uses that data only. I only need one word doc at a time.

When I try Options > click "Views" > OPEN SCAR (the query I want)... it always causes an error



I have tried to use a macro that opens the query first, then RunCode, it still asks for the table in Word.

Any ideas?
Reply With Quote
  #2  
Old 12-10-2012, 05:28 AM
ChrisMan ChrisMan is offline Mail Merge from Access Query to Word Windows 7 32bit Mail Merge from Access Query to Word Office 2003
Novice
Mail Merge from Access Query to Word
 
Join Date: Dec 2012
Posts: 2
ChrisMan is on a distinguished road
Default

Monday morning bump. Anyone?
Reply With Quote
  #3  
Old 12-10-2012, 11:22 PM
macropod's Avatar
macropod macropod is offline Mail Merge from Access Query to Word Windows 7 64bit Mail Merge from Access Query to Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

This isn't an area I'm especially familiar with, but it seems to me your line:
Connection:="QUERY OPEN SCAR",
might be an issue. Unless 'Open' is part of the query name (which doesn't seem to be the case, it should be:
Connection:="QUERY SCAR",

For more on mailmerge programing see:
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
http://www.tek-tips.com/faqs.cfm?fid=3237
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word (Mail Merge) Refreshes Query Too Often! amarsha4 Mail Merge 1 11-10-2010 09:12 AM
mail merge from access query or two tables peter Mail Merge 0 08-24-2010 05:32 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM
Mail Merge from Access Query to Word Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft