I have an acrobat document that includes the report of about 200 customers. Each customer has a report size varying from 2 to 6 pages. I have the names of these customers stored in MS Excel. I would like to write a macro to split the report of some customers and save with the customer name...
I have the following code to send an attacjment specified in a an excel cell to a list given in excel. Now I have a new project at work to modify this code to send all the files in a given folder. Each person in the list have a different set of files but each person's files are saved under the...
Rob,
I tried to include your codes into mine but somehow, I could not have it working, I think that may be because I have excel and outlook 2002. I have the following message "outlook.application could not be found".
Thanks for helping.
Conte
Hi Tony,
The report works exactly the same as you say. Each report starts on a new page and the customer name is in the same place on every page. What should the code look like then?
Thanks
I have to following codes to automate email distribution. Tne email list is an excel file. But everytime a new email is created and to be sent, a screen saying "A program is trying to send email automatically on your behalf. Do you want to allow this?"pops up. But when you are sending...
Tony,
This is another issue. We run these reports almost 2-3 times a week and the length of each cutomer report is different every time we run. Lets say ABC Company has 2 pages on today's report, but tomorrow the same company may have report of 3 or 4 pages. And it is not easy to anticipate the...
I have a word document that includes the report of about 200 customers. Each customer has a report sizevarying from 2 to 6 pages. I have the names of these customers stored in MS Excel. I would like to write a macro to delete the report of some customers automatically. The number of customers...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.