Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2005

Tip: Looking for answers? Try searching our database.

Mail Merge Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Know your Word... - 16 Jun 2005 21:52 GMT
I'm trying to simplify the mail merge process to create bulk envelopes.  I
figure this will save the other guys from having to complete the six step
merge process.  I wanted to have setup  the macro to run, as step one, and
just exclude the addresses not wanted as step two... process finished.  
However, after I've created the macro and then try running it all the data is
jumbled up in the left corner of the screen and the page orientation is
always portrait even after I specified the envelope size.  Everything looks
ok while recording the macro but when you run it you get a different look and
feel.  I'm thinking maybe the macro is not recording relative to screen
position, orientation or paper size.
Peter Jamieson - 17 Jun 2005 10:43 GMT
Unfortunately, Macro recording has a number of problems - e.g., the recorder
does not necessarily record all of your actions. It's usually also important
to run the macro from the same starting point that you used when you
recorded the macro (e.g. if you started from a blank document, you need
either to run the macro starting from a blank document or modify the macro
in some way).

You could try copying/pasting your existing macro code into a message and
posting it here and see if anyone can spot what needs to be changed.

Peter Jamieson

> I'm trying to simplify the mail merge process to create bulk envelopes.  I
> figure this will save the other guys from having to complete the six step
[quoted text clipped - 19 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=7afc5e37-5d25-4
cae-bd2b-847495e49833&dg=microsoft.public.word.mailmerge.fields
 

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.