Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2010, 07:47 AM
sedain121 sedain121 is offline Saving INDV mail merges During the mail merge Windows Vista Saving INDV mail merges During the mail merge Office 2007
Novice
Saving INDV mail merges During the mail merge
 
Join Date: Jun 2010
Posts: 3
sedain121 is on a distinguished road
Default Saving INDV mail merges During the mail merge

I am trying to mail merge an access database and everything works fine. Only i dont want to print the list, I want to save each recipiant individually so I can email the file with the info filled out instead of the fields.

So I started saving the individual filled out files but when I go to open the file it asks me where the database is even though the data is already filled out.

I want to be able to mail merge the info onto the file then save the files individually so someone else can open them with out the database prompt.

Now I found a fix to this by opening the saved file on its own and then resaving it with a different name as a word file again. This seems to get rid of the database prompt to fill in the fields again and makes it a single file filled out ready to email.

My problem is when I save these files during the mail merge as word files they still retain the database prompt until i go in each one, after i saved them through the mail merge, and resave them as word file again with a different name.

How can I only save them once during the mail merge? I am clicking save as and specifying the word document choice.

Thanks
Reply With Quote
  #2  
Old 10-04-2011, 04:03 PM
TeriJean TeriJean is offline Saving INDV mail merges During the mail merge Windows Vista Saving INDV mail merges During the mail merge Office 2010 32bit
Novice
 
Join Date: Oct 2011
Posts: 2
TeriJean is on a distinguished road
Default

Did you ever get an answer to this? It sounds like something I may have to deal with later on.
Reply With Quote
  #3  
Old 10-04-2011, 07:52 PM
macropod's Avatar
macropod macropod is offline Saving INDV mail merges During the mail merge Windows 7 64bit Saving INDV mail merges During the mail merge 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

The problem description suggests the OP was merely previewing the merge for each record from the mailmerge main document, then saving a copy of the preview without ever executing the mailmerge.

The normal process for generating individual files from a mailmerge entails executing the mailmerge then using a macro to split the output into separate files. Numerous such macros are available on the web. A more sophisticated approach is to drive the whole process from a macro that uses one or more fields from the data source as part of the output file names. Again, such macros can be found via a web search. See, for example: http://www.gmayor.com/individual_merge_letters.htm.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge help aman Mail Merge 0 05-07-2010 03:38 AM
Saving INDV mail merges During the mail merge help with a mail merge akim281 Mail Merge 2 02-05-2010 02:54 PM
Mail Merge hiteshkataria Mail Merge 4 11-06-2009 05:11 AM
Saving INDV mail merges During the mail merge mail merge Anthony Outlook 1 09-29-2009 06:09 PM
Saving INDV mail merges During the mail merge Saving sent mail online ahmex Outlook 1 04-27-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 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