×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Word Mail Merge for mobile devices

Word Mail Merge for mobile devices

Word Mail Merge for mobile devices

(OP)
Hello,

We have several Word mail merge 'template' files (we call them notices and saved as a regular Word document).
The files contain database mail merge fields.

We have a dos batch process that opens the notice template file and activates macros to connect to the datasource and populate the mail merge fields.
This process works great.

I added a new macro for emailing the file (either as an attachment or as the main text body of the message).
This process is working fine.

Here's the issue.
The word document was created on an 8.5 x 11 page.
When the mail merge is complete, the file is the same as the original file.
This is way to big for mobile devices.

What would I need to do so that the notice is mobile friendly and can be viewed on mobile devices, such as a phone?

Note: I have never programmed anything for mobile devices and my main development machine is Windows 7 with Office 2007.

Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

RE: Word Mail Merge for mobile devices

Hi,

"way to big for mobile devices"

...a definite maybe.

I have several Word files with 10 point font that I can read on my 2.4" x 4" iPhone 8, with my 78 year old eyes. Wouldn't want to read a lot of that, but it's doable.

You other option is to redo the page layout. But I don't know of any way to transform an 8.5 x 11 once you've sent it.

Or am I missing something?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Word Mail Merge for mobile devices

(OP)
Hi Skip,

Thanks for the response.
I wasn't sure if an 8.5 x 11 document could be converted (before emailing it).

I can certainly recreate the document in a new format/page layout.
I just don't know what to adjust (ex. page size, font size, etc.)

The current document is only one 8.5 x 11 page.
As long as I can place the merge fields and some text, it should be fine.

If at first you don't succeed, then sky diving wasn't meant for you!

RE: Word Mail Merge for mobile devices

Quote:

I wasn't sure if an 8.5 x 11 document could be converted (before emailing it).

Yes! The MailMerge result is a Word Document.

Make appropriate changes to the MailMerge result in Layout. It may take several iterations of changing page size & font size at a minimum and viewing the results on a variety of mobile devices until you arrive at a satisfactory solution. I have had to do this for various outputs many many times over the past two and a half decades.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Word Mail Merge for mobile devices

(OP)
Thanks Skip.

That's what I thought I'd have to do.
I will modify the original template, perform the mail merge, and email the file and repeat until it looks good.

Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close