mail merge; vba

Please help on figuring this out as I'm stuck at the last stage trying to properly define my variables in the following code. I want to execute the following in sequence: 1. Click the button 'CommandButton1' 2. The Form called 'CR_MMFormTest', which is an embedded document, will then open...

Hi All, I am new to vba. i have found a word vba which is saving individual mail merge to pdf files. But for this i have to pick the folder to store the pdf files. Is it possible to modify the macro to automatically save all files to a particular folder location instead of manually selecting...

Hello, I have a large inventory list I've created in excel. I need a macro to create X number of labels from data in the table. It has 13 columns and a running number of rows. I've been looking around for a few months now but haven't found anything that works for me. Is this even possible? does...

Hi All, I am new to vba. i have found a word vba which is saving individual mail merge to pdf files. But for this i have to pick the folder to store the pdf files. Is it possible to modify the macro to automatically save all files to a particular folder location instead of manually selecting...

I have written this Macro to generate an already linked Mail Merged Doc by simply pushing a Form Control button in Excel: Sub OpenMailMergeDoc() Dim wrdApp As Object Dim wrdDoc As Object Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = True Set wrdDoc =...

Every month we run a standard mailmerge to send a number of emails. After the emails are sent, we create an excel workbook which relates to each of the emails sent. I would like to automate this process rather than manually creating 200 workbooks! I would like to copy all of the data in the...

Hello, I am trying to create a merge template of my faculty "database" (not a true database, but a massive spreadsheet that acts as a reporitory of info). The issue I am running into is a faculty member will have several activities listed, but I only want 1 document generated with all of the...

I can not seem to figure this one out. I want to open Mail merge from my excel spreadsheet with a button. I need word to open with my mail merge template and pull data from the spreadsheet that I have open with the button on it. No one has answered me on any forum yet. Is this impossible to...

I am trying to open my mail merge document straight from my data source in excel with a button. I have tried to type a code with help from several forums but I am not having any luck. I recieve a Run Time error424 when I run the macro. I am using Excel and Word 2007. The line that the debug...

If someone has a solution to this problem, I would be very grateful!! I'm no expert in VBA, so any help you can provide would be most helpful. I have my data in Excel 2007, protected by a password to open file, and read only password. I have a form in Word 2007. The user opens the Excel...

Ok, I've done mail merges for print...usually connecting a list of names and addresses in an Excel spread to a Word doc. Cake. I haven't done much with personalizing form letters using merge fields, but I know how it's done. What I haven't done is what I'd like to do now- create personalized...

Hello! Introduction : I need to make the blood test report of my patients. I routinely use a set of data which is saved in excel 2010 and mailmerge it in word. Example : Column A has the patients names, Column B has the RBC count, Column C has the WBC count and so on and so forth. So the...

Hello forum, i made a report in Access to create invoices of separate pages. what i need next is to have this each page saved separately ( individual file) in PDF somewhere on my drive.the name of the file should be the invoice number that appears on the invoices which is in field [Invoice...