Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2014, 11:58 PM
iamrickdeans iamrickdeans is offline Mail Merge To Individual PDF Files Windows 7 64bit Mail Merge To Individual PDF Files Office 2010 64bit
Novice
Mail Merge To Individual PDF Files
 
Join Date: Jan 2014
Posts: 1
iamrickdeans is on a distinguished road
Default Mail Merge To Individual PDF Files

I am sorry that this has probably been asked a thousand times but I cannot find exactly what I am looking for and have spent about three days trying to work it out to some success but not a lot.

I have a datasource that at the moment it in an access database but it can be happily exported to excel if it is easier?

I have a mail merge template called 'merge'

The database I am performing the merge from is called 2011.accdb
and it has a singular table called 2011.

My aim is to perform a mail merge on the data from within this table or from an excel data source using the field called 'ClientAccountNumber'

And use 'ClientAccountNumber' as the data to save the individual PDF's as.

Please let me know if anything needs clarifying I cannot work it out and am desperately in need of a solution.



Many thanks in advance for anyone who can help push me in the right direction or provide a tutorial on how it is done!

Regards

Richard
Reply With Quote
  #2  
Old 01-15-2014, 12:46 AM
macropod's Avatar
macropod macropod is offline Mail Merge To Individual PDF Files Windows 7 32bit Mail Merge To Individual PDF Files Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,230
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

For that you might want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at https://skydrive.live.com/?cid=5aedc...615E886B%21566
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge tables, pdf conversion, save as

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Mail Merge to multiple .doc files named after a mergefield nicnad Mail Merge 1 02-22-2012 01:59 AM
Mail Merge and Files on Network Drive Joe Switch Mail Merge 0 09-15-2011 09:06 AM
Macro to export document sections to individual txt files? MJMR999 Excel Programming 0 02-18-2010 12:49 PM
individual merge letters ahmed_tr Word 2 06-27-2009 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 PM.


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