Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro Mail Merge

Status
Not open for further replies.

RAxel

MIS
Sep 8, 2005
121
US
I'm curious as to how complex a macro can get. I'm making a macro for a mail merge and getting an error. These are the steps I'm doing:

1. Tools -> Letters and Mailings -> Mail Merge
2. Click Envelope radio button
3. Click Next: Starting Document
4. Click Change document layout radio button
5. Click Envelope options...
6. Leave everything as default and click OK
7. Click Next: Select recipients
8. Click Select from Outlook contacts
9. Choose Contacts Folder... I choose the contact folder in my mailbox, then click Select All, then click OK
10. Click Next: Arrange your envelope
11. Click the middle of the envelope and then click Address Block
12. Leave it as the default and click OK
13. Click Next: Preview your envelopes
14. Click Next: Complete the merge


Now, I could end it here, but I went ahead and hit the print button and changed some settings there to make it even more automated. The place where I'm getting the error is when the <<Address Block>> appears on the screen. What is weird is that the <<Address Block>> should appear AFTER the layout has changed to envelope, but it doesn't. And the <<Address Block>> appears on the top left of the screen, not in the middle where it is supposed too.

Finally, the layout doesn't change to the correct envelope layout and I don't believe Word grabs the contacts from Outlook and that's where I believe the error occurs. Any help is appreciated.
 
I suppose a follow up question would be, if there are multiple contact selections, is there some vba code that will actually print out every <<Address Block>> from the 1st record to the last record?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top