+ Reply to Thread
Results 1 to 2 of 2

Trying to pull off a custom address mail merge process!

  1. #1
    Registered User
    Join Date
    08-30-2007
    Posts
    28

    Lightbulb Trying to pull off a custom address mail merge process!

    I am automating a mail merge type process for a user.

    EXPLANATION MY PROCESS THOUGHTS
    User is in excel on data sheet. They select the address to use. They click a button to run this macro that does the following...

    Active Selection (I will call this "Cell 1")
    Copy Selection
    Paste into another sheet (I will call this "A1", it is the master cell of the data)
    Alt+Enter A1 (preps the format for next piece of data being copied in)
    offset cell 1 by (0,2) for next piece of data
    copy it
    paste in A1

    Repeat untill address is complete.

    Then copy A1 to clipboard
    Open Avery 5160 word file I have (I know how to do this)

    User will then Paste their address

    for added effect because they can add several addresses into the document I would like to then have the code know after the paste has been done, ask the user if they want to print yet.
    No= save and close word doc
    Yes= print (they can close it manually at that point)


    Anyone throw me something I can run with? Did I explain well/any questions? Thanks for any help, I know its a lot to grasp!

  2. #2
    Registered User
    Join Date
    08-30-2007
    Posts
    28
    Anyone done this before at all?
    Branden
    *Currently Noob VBA Scripter but I know excel pretty well otherwise.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1