When using the envelope printing function in MS Word (2007), how do you utilize the specific "print envelope" settings in combination with the mail merge function?
I just attempted to do this as follows: In MS Word, I clicked on the Envelopes option (under the Mailings tab) which opened the Envelopes and Labels box (Fig. 1):
In that box I clicked the Options button which led to the Envelope Options box (Fig. 2):
Next, I specified the position for the delivery address (the return address was already on the back of the envelope) and clicked OK which took me back to the Envelopes and Labels box (Fig. 1) where I clicked the Print button. Doing so, immediately activated the printer and an envelope was successfully printed.
Once that portion of the task was completed, I began creating the mail merge by defining an Excel spreadsheet as the data source (selecting recipients), editing the recipient list, and inserting the merge fields (Fig. 3):
I then used the Preview Results button to verify the printing format was correct, double checked the number of envelopes to be printed, and clicked the Finish & Merge button (Fig. 4):
This resulted in the appearance of the small (and familiar) Merge to Printer box (Fig. 5) where I initially chose to print only the current record so as to double check the positioning, etc., on a test envelope.
Clicking OK here resulted in a Print box which I have not seen since upgrading MS Office (Fig. 6).
Assuming everything was as it should be, I clicked the OK button to send the print command. However, to my surprise, the resulting printed envelope came out with only half of the address printed on the edge of the envelope and turned 90° from where it was supposed to be.
After trying a few different things, I realized, or rather I suspect, that I am somehow ending up in a different print signal place than where I want to be. This is because, with the single envelope printing described above, the print command was sent from the box shown in Fig. 1, whereas now it was going from the box shown in Fig. 6.
Finally, noticing that clicking the Print button in the box in Fig. 1, sends the print command immediately -- without the intermediary Merge to Printer box (Fig. 5) -- causes me to wonder if doing a mail merge with envelopes is even possible.
1) Is it even possible to do a mail merge when printing envelopes? If not, then the only other option seems to be to use the Envelope box print command. However, that is extremely cumbersome and time-consuming since I can find no way to save the custom positioning settings in the Envelope Options box (Fig. 2).
2) If it is possible to print envelopes using mail merge, then are the settings and positioning, etc., defined through a typical mail merge process (i.e. no different than printing a standard document)?
3) If yes (to #2), what is the point of having the Envelope printing option?
4) If I've just got this all screwed up, please indicate the correct steps for getting envelopes printed in the most effective way.
FYI, the envelope printing is for my son who is getting married soon.
He keeps telling his fiancée:
"Don't worry, Dad will have this figured out soon."
I keep telling him:
"Don't worry, I will have this figured out soon."
and I keep telling myself:
"Don't worry, the experts at EE will have this figured out soon."
So consider this one to be for the beautiful bride! :)