Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2014, 02:40 PM
Queenofmycastle Queenofmycastle is offline Can I do an automated mail merge with Excel, Word, and Publisher? Windows 8 Can I do an automated mail merge with Excel, Word, and Publisher? Office 2013
Novice
Can I do an automated mail merge with Excel, Word, and Publisher?
 
Join Date: Oct 2014
Posts: 8
Queenofmycastle is on a distinguished road
Default Can I do an automated mail merge with Excel, Word, and Publisher?

I provide 4 hour Parenting Classes for people in custody disputes. For years I have maintained three separate files. I keep a list in Excel that includes the Persons Name and attendance date. I have a letter in Word that the name and attendance date is the only change a certificate in Publisher with the same changes. I would like to simplify this all into one file? All help appreciated!
Reply With Quote
  #2  
Old 10-12-2014, 03:23 PM
macropod's Avatar
macropod macropod is offline Can I do an automated mail merge with Excel, Word, and Publisher? Windows 7 64bit Can I do an automated mail merge with Excel, Word, and Publisher? 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

Whether mailmerge, which both Word and Publisher support, would be of benefit really depends on:
(a) how many letters and certificates at a time you are producing; and
(b) how your Excel data are organised.
Mailmerges are designed for mass-production and really don't offer much benefit for the processing of only a few records at a time.

To be useful as a mailmerge data source, your Excel workbook would have to be set up in a table format, with separate columns for each of the elements needed for the mailmerges (e.g. dates, honorifics, given names/initials, surnames, street addresses, localities, zip/postal codes, state, etc.) and with all elements for a given record on the same row.

And, rather than using separate Word and Publisher files, you should consider whether either of those programs can do the job on their own. It might be possible, for example, to save the Publisher file in Word format, so you can incorporate the certificates into the same document that produces the letters. The converse might also be true.

You'll necessarily end up with at least two files, one being the Excel data source but, depending on your requirements and the data structure, you may not need to do any typing in the mailmerge main document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-12-2014, 05:02 PM
Queenofmycastle Queenofmycastle is offline Can I do an automated mail merge with Excel, Word, and Publisher? Windows 8 Can I do an automated mail merge with Excel, Word, and Publisher? Office 2013
Novice
Can I do an automated mail merge with Excel, Word, and Publisher?
 
Join Date: Oct 2014
Posts: 8
Queenofmycastle is on a distinguished road
Default I never realized

That you might could save a publisher file as a word file! I'm going to check it out right now. would it be possible for the publisher file to be a sheet in the excel file?
Reply With Quote
  #4  
Old 10-12-2014, 05:31 PM
macropod's Avatar
macropod macropod is offline Can I do an automated mail merge with Excel, Word, and Publisher? Windows 7 64bit Can I do an automated mail merge with Excel, Word, and Publisher? 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

Quote:
Originally Posted by Queenofmycastle View Post
would it be possible for the publisher file to be a sheet in the excel file?
No. As I said, the files need to be separate.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-12-2014, 10:23 PM
gmayor's Avatar
gmayor gmayor is offline Can I do an automated mail merge with Excel, Word, and Publisher? Windows 7 64bit Can I do an automated mail merge with Excel, Word, and Publisher? Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The files need to be separate i.e the data in Excel the documents in Word or Publisher (Word will provide more functionalty - Publisher makes the production of stylish documents simpler). The documents can be connected seamlessly to the data.

If you can reproduce the certificate design in Word I would do so. You can then either use a VBA userform to read the data into a combo box or list box and select the record(s) to be processed, or use mail merge, but as Paul says, they will be separate documents.

See http://www.gmayor.com/Userform.htm and for a more in depth explanation, see http://gregmaxey.com/Create_and_employ_a_UserForm.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge table from Excel to Word krezumica Mail Merge 2 03-06-2014 10:26 PM
Can I do an automated mail merge with Excel, Word, and Publisher? Word mail merge from a protected Excel worksheet Platform Mail Merge 10 09-28-2011 05:12 AM
Can I do an automated mail merge with Excel, Word, and Publisher? Mail merge picture into Publisher from URL BlueSprint Publisher 1 07-31-2011 03:06 PM
Can I do an automated mail merge with Excel, Word, and Publisher? Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
Help with switches: Word mail merge with Excel ks_ Mail Merge 0 12-09-2009 05:09 PM

Other Forums: Access Forums

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