Email docs from word doc by individual pages

[Holley]

Hello all! I have a manual task that I am sure could be automated - I'm just at a loss of how to do it. I have a text file that I open in a word template with a company logo. There can be up to 70 pages. Each page break will need to be a different email. The email address is in the same location on each page as is the customer #. Would it be possible to run a macro that will copy the text (even if a page at a time), and paste it into an Outlook message? To make it even better is if it could copy the email address and customer # and past in the appropriate fields? Attached is an example of one page. The highlighted fields are static.

Thanks as always!

 

[HighAndWilder]

Hello all! I have a manual task that I am sure could be automated - I'm just at a loss of how to do it. I have a text file that I open in a word template with a company logo. There can be up to 70 pages. Each page break will need to be a different email. The email address is in the same location on each page as is the customer #. Would it be possible to run a macro that will copy the text (even if a page at a time), and paste it into an Outlook message? To make it even better is if it could copy the email address and customer # and past in the appropriate fields? Attached is an example of one page. The highlighted fields are static.
View attachment 101776
Thanks as always!

Where does the data for the statement come from?

If it is in Excel then why not create a PDF file in Excel and attach the PDF file to an email?

 

[Holley]

Where does the data for the statement come from?

If it is in Excel then why not create a PDF file in Excel and attach the PDF file to an email?

Thanks for the fast response! Its in Word. We are currently copying the information and pasting it into an Outlook message that is saved that has the company logo. Management is trying to avoid sending as attachments as space is limited.... at least thats what I'm getting.

 

[HighAndWilder]

Thanks for the fast response! Its in Word. We are currently copying the information and pasting it into an Outlook message that is saved that has the company logo. Management is trying to avoid sending as attachments as space is limited.... at least thats what I'm getting.

How do the statement lines get into Word?

Do they originate in a Sales Ledger system?

 

[Holley]

How do the statement lines get into Word?

Do they originate in a Sales Ledger system?

I download a text file from our system and paste into word. Thankfully, it keeps the page breaks and formatting.

 

[HighAndWilder]

I download a text file from our system and paste into word. Thankfully, it keeps the page breaks and formatting.

There must be an easier way.

Can you create a csv file of the statement details for all customers from your system?

 

[Holley]

There must be an easier way.

Can you create a csv file of the statement details for all customers from your system?

I'll see if that is an option...

 

[Holley]

There must be an easier way.

Can you create a csv file of the statement details for all customers from your system?

I am able to download as csv, but there is no formatting and seems to be all over the place. I'm not that familiar with working with csv files, so that may be par for the course.

 

[HighAndWilder]

I'll see if that is an option...

I am able to download as csv, but there is no formatting and seems to be all over the place. I'm not that familiar with working with csv files, so that may be par for the course.

But that is what we are here for.

Can you open it in Excel and post an example using XL2BB?

 

[Holley]

But that is what we are here for.

Can you open it in Excel and post an example using XL2BB?

and I am so grateful too!! I will not be able to do that until later tonight. It is blocked here at work and I can do it when I get home from my PC.